x$kglrd. 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
;