I'm not sure about the SELECT/INSERT/UPDATE or the package level stuff, but I think I've read in docs about how to turn full sql logging on and off. Mind you I've never actually tried it, so anyone with actual experience in this is welcome to correct me :)
Anyway, since we're using hibernate and EJB I think you can set the following property in your persistence.xml (after jta-data-source):
<properties> ... <property name="hibernate.show_sql" value="true"/> ... </properties>
According to the Hibernate documentation regarding this property:
This is an alternative to setting the log category org.hibernate.SQL to debug.
Hope that works!