Query user_dependencies : user_dependencies « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. user_dependencies

SQL> SELECT    name, type
  2  FROM      user_dependencies
  3  WHERE     referenced_name = UPPER('&object_name')
  4  AND       referenced_type = UPPER('&object_type')
  5  and       rownum < 2
  6  ORDER BY  name;