title: How to find all table references from Oracle 10G PL/SQL functions and procedures?
body: <p>How to find all table references from Oracle 10G PL/SQL functions and procedures?</p>
  
  <p>I definitely can execute the following SQL statement:</p>
  
  <pre><code>select * from dba_source where text like '%tbl_c%'
  </code></pre>
  
  <p>but I wonder how to find all functions that call functions that refer to table used.  For example I can have a function A that calls function B that uses table tbl_c.  If I'll execute aforementioned SQL I'll find funciton B but then I have to execute another SQL to find A.  As you know the cyclomatic complexity could be 3,4,5 levels deep or even greater.</p>
  
  <p>Greatly appreciate in advance for your explanation.</p>