Queries involving the table under the stored procedure: select * from dba_dependencies t
Where t.r eferenced_owner=[user]
And t.t ype='PROCEDURE'
And t.r eferenced_type='TABLE'
And NAME=[PROCEDURE_NAME]