title: How to find out what tables/views/synonyms are used in a stored procedure
body: <p>Through Oracle queries is it possible to find out which views/synonyms/tables a stored procedure use?  </p>
  
  <p>In PL/SQL Developer if you collapse out a stored procedure it will show "References" which shows all the tables/views/synonyms that the stored procedure uses.  </p>
  
  <p>I am trying to implement this functionality into a script which will come in handy.  </p>
  
  <p>Wondering if anyone knows a script that will fetch me all the synonyms/views/tables that a stored procedure uses?</p>