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 ;