SQL>
SQL> SELECT name, type, referenced_owner r_owner, referenced_name r_name,
2 referenced_type r_type
3 FROM user_dependencies
4 WHERE name IN ('CALL_TEST_PROC', 'TEST_PACK')
5 OR referenced_name IN ('CALL_TEST_PROC', 'TEST_PACK');
NAME TYPE R_OWNER
------------------------------ ----------------- ------------------------------
R_NAME
----------------------------------------------------------------
R_TYPE
-----------------
TEST_PACK PACKAGE BODY SYS
STANDARD
PACKAGE
CALL_TEST_PROC PROCEDURE SYS
SYS_STUB_FOR_PURITY_ANALYSIS
PACKAGE
NAME TYPE R_OWNER
------------------------------ ----------------- ------------------------------
R_NAME
----------------------------------------------------------------
R_TYPE
-----------------
TEST_PACK PACKAGE BODY PUBLIC
DBMS_OUTPUT
SYNONYM
TEST_PACK PACKAGE BODY RNTSOFT
DBMS_OUTPUT
NAME TYPE R_OWNER
------------------------------ ----------------- ------------------------------
R_NAME
----------------------------------------------------------------
R_TYPE
-----------------
NON-EXISTENT
CALL_TEST_PROC PROCEDURE RNTSOFT
TEST_PACK
PACKAGE
TEST_PACK PACKAGE BODY RNTSOFT
NAME TYPE R_OWNER
------------------------------ ----------------- ------------------------------
R_NAME
----------------------------------------------------------------
R_TYPE
-----------------
TEST_PACK
PACKAGE
6 rows selected.
SQL>