How to find dependencies inside an oracle package?
<p>My question is how to find inside oracle package dependencies by SQL query or any other internal/external tool. Is it even possible or should I just go trough the code and find out myself? </p>

<p>Example case:</p>

<ul>
<li>I have a package which contains 4 procedures <code>A</code>, <code>B</code> ,<code>C</code>, <code>D</code> and 1 function <code>F</code>. </li>
<li><code>A</code> is the <em>'main'</em> procedure which runs <code>B</code> and <code>C</code> procedures.</li>
<li>Function <code>F</code> is used by <code>B</code> and <code>C</code> procedures.</li>
<li>Procedure <code>D</code> is independent (used elswhere).</li>
</ul>

<p>Now I'd like to obtain something like this as a result:</p>

<pre><code>STATUS      PRC/FNC NAME  PRC/FNC NAME USED INSIDE
------      ------------  ------------------------
MAIN        A             B, C
SLAVE       B             F
SLAVE       C             F
INDIVIDUAL  D             -
SLAVE       F             -
</code></pre>

<p>I've searched stack for an answer and the closest I've found would be: <a href="https://stackoverflow.com/questions/297465/how-do-you-programatically-identify-a-stored-procedures-dependencies/297873#297873">How do you programatically identify a stored procedure&#39;s dependencies?</a>
But it gives me only between-packages dependencies, not a dependencies 'inside' one package.</p>