Search notes:

X$KGLDP

Object dependency.
Compare with read only dependencies in x$kglrd.

Join with X$KGLOB

x$kgldp can be joined to x$kglob and x$kglxs:
select
   xob.kglnaobj,
   cur.kglnaobj,
   xob.kglnaobj
from
   x$kglob xob                                      join
   x$kgldp dep  on xob.kglhdadr = dep.kglrfhdl      join
   x$kglob cur  on dep.kglhdadr = cur.kglhdadr      join
   x$kglxs axs  on dep.kglhdadr = axs.kglhdadr and        --  make sure it is not a transitive
                   dep.kgldepno = axs.kglxsdep            --  reference, but a direct one
where
    cur.kglhdnsp = 0 -- a cursor
;

See also

dba_dependencies
fixed table
$ORACLE_HOME/rdbms/admin/utldtree.sql

Index