select /*+ leading(d) use_nl(o) */
level as "LEVEL", d.owner as "OWNER", d.name as "NAME", d.type as "TYPE", o.status as "STATUS",
d.reference_owner as "REFERENCED_OWNER", d.referenced_name as "REFERENCED_NAME", d.referenced_type as "REFERENCED_TYPE"
from dba_dependencies d, dba_objects o
where
d.referenced_owner not in ('SYS','SYSTEM','PUBLIC')
and d.referenced_owner not in ('SYS','SYSTEM','PUBLIC')
and d.referenced_type != 'NON-EXISTENT'
and o.owner = d.owner and o.object_name = d.name and o.object_type = d.type
start with d.referenced_owner = 'A' and d.referenced_name = 'XYZ'
connect by prior d.owner = d.referenced_owner and prior d.name = d.referenced_name and prior d.type = d.referenced_type;

LEVEL OWNER NAME           TYPE STATUS REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
----- ----- ----   ------------ ------ ----------------  -------------- ---------------
1         A   A1   PACKAGE BODY  VALID                A             XYZ           TABLE
1         A   A2   PACKAGE BODY  VALID                A             XYZ           TABLE
1         A   A3   PACKAGE BODY  VALID                A             XYZ           TABLE
1         A   A4   PACKAGE BODY  VALID                A             XYZ           TABLE