Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 (
  id NUMBER
     GENERATED ALWAYS AS IDENTITY
     PRIMARY KEY
); 
CREATE TABLE table2 (
  id NUMBER
     GENERATED ALWAYS AS IDENTITY
     PRIMARY KEY
);
CREATE TABLE table3 (
  id NUMBER
     GENERATED ALWAYS AS IDENTITY
     PRIMARY KEY
);
CREATE PACKAGE package1 IS
  PROCEDURE proc1_1 (id IN table1.id%TYPE);
END;
/
CREATE PACKAGE BODY package1 IS
  PROCEDURE proc1_1 (id IN table1.id%TYPE)
  IS
  BEGIN
    INSERT INTO table3(id) VALUES (DEFAULT);
  END;
END;
/
CREATE PACKAGE package2 IS
  PROCEDURE proc2_1 (
    id1 IN table1.id%TYPE,
    id2 IN table2.id%TYPE
  );
END;
/
CREATE PACKAGE BODY package2 IS
  PROCEDURE proc2_1 (
    id1 IN table1.id%TYPE,
    id2 IN table2.id%TYPE
  )
  IS
  BEGIN
    package1.proc1_1(id1);
  END;
END;
/
SELECT *
FROM   ALL_DEPENDENCIES
WHERE  OWNER = USER;


OWNER
NAME
TYPE
REFERENCED_OWNER
REFERENCED_NAME
REFERENCED_TYPE
REFERENCED_LINK_NAME
DEPENDENCY_TYPE


FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE1
PACKAGE
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE1
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE1
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE1
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE1
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE1
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE2
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE2
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE1
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE3
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE1
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE1
PACKAGE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE1
PACKAGE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE
null
HARD


SELECT DISTINCT *
FROM   ALL_DEPENDENCIES
WHERE  REFERENCED_TYPE = 'TABLE'
START WITH
       OWNER = USER
AND    TYPE  = 'PACKAGE'
AND    NAME  = 'PACKAGE2'
CONNECT BY NOCYCLE
       (   PRIOR REFERENCED_OWNER = OWNER
       AND PRIOR REFERENCED_NAME  = NAME
       AND PRIOR REFERENCED_TYPE  = TYPE
       )
OR     (   PRIOR OWNER = OWNER
       AND PRIOR NAME  = NAME
       AND PRIOR TYPE  = 'PACKAGE'
       AND TYPE        = 'PACKAGE BODY'
       )
ORDER BY owner, name, type, referenced_name;


OWNER
NAME
TYPE
REFERENCED_OWNER
REFERENCED_NAME
REFERENCED_TYPE
REFERENCED_LINK_NAME
DEPENDENCY_TYPE


FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE1
PACKAGE
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE1
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE1
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE1
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE1
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE3
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE1
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE2
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE1
TABLE
null
HARD

FIDDLE_ZZBINTUDVOSFUCNFPDFW
PACKAGE2
PACKAGE BODY
FIDDLE_ZZBINTUDVOSFUCNFPDFW
TABLE2
TABLE
null
HARD

OWNER	NAME	TYPE	REFERENCED_OWNER	REFERENCED_NAME	REFERENCED_TYPE	REFERENCED_LINK_NAME	DEPENDENCY_TYPE
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE1	PACKAGE	FIDDLE_ZZBINTUDVOSFUCNFPDFW	TABLE1	TABLE	null	HARD
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE1	PACKAGE BODY	FIDDLE_ZZBINTUDVOSFUCNFPDFW	TABLE1	TABLE	null	HARD
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE2	PACKAGE	FIDDLE_ZZBINTUDVOSFUCNFPDFW	TABLE1	TABLE	null	HARD
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE2	PACKAGE BODY	FIDDLE_ZZBINTUDVOSFUCNFPDFW	TABLE1	TABLE	null	HARD
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE2	PACKAGE	FIDDLE_ZZBINTUDVOSFUCNFPDFW	TABLE2	TABLE	null	HARD
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE2	PACKAGE BODY	FIDDLE_ZZBINTUDVOSFUCNFPDFW	TABLE2	TABLE	null	HARD
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE1	PACKAGE BODY	FIDDLE_ZZBINTUDVOSFUCNFPDFW	TABLE3	TABLE	null	HARD
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE1	PACKAGE BODY	FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE1	PACKAGE	null	HARD
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE2	PACKAGE BODY	FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE1	PACKAGE	null	HARD
FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE2	PACKAGE BODY	FIDDLE_ZZBINTUDVOSFUCNFPDFW	PACKAGE2	PACKAGE	null	HARD