title: How to get the name of stored procedure within a package and a schema accessing a particular table in Oracle?
body: <p>I have used following query to get the procedure list but I am getting just the schema name and package name. If the TYPE Column returns PACKAGE BODY, then how to get the procedure name within the package accessing the table EXCEPTIONAL_INFO, please help.</p>
  
  <pre><code>SELECT * FROM All_DEPENDENCIES WHERE REFERENCED_NAME = 'EXCEPTIONAL_INFO';
  </code></pre>