APPS.ETRM_PNAV dependencies on CDEF$

Line 619: -- fk details from sys.cdef$ because dba_constraints id slow

615: return v_return_val;
616: end dba_object_info;
617:
618: procedure ls_table(n_object_id in dba_objects.object_id%type) is
619: -- fk details from sys.cdef$ because dba_constraints id slow
620:
621:
622: cursor cur_fk(n_object_id in dba_objects.object_id%type) is
623: select etrm_pnav.get_object_name(robj#, 'RAW') table_name

Line 626: from sys.cdef$

622: cursor cur_fk(n_object_id in dba_objects.object_id%type) is
623: select etrm_pnav.get_object_name(robj#, 'RAW') table_name
624: , robj# object_id
625: , con# cons_id
626: from sys.cdef$
627: where obj# = n_object_id
628: and robj# is not null
629: order by etrm_pnav.get_object_name(robj#);
630:

Line 635: from sys.cdef$

631: cursor cur_fk2(n_object_id in dba_objects.object_id%type) is
632: select etrm_pnav.get_object_name(obj#, 'RAW') table_name
633: , obj# object_id
634: , con# cons_id
635: from sys.cdef$
636: where robj# = n_object_id
637: order by etrm_pnav.get_object_name(obj#);
638:
639: