APPS.ETRM_RPT dependencies on DEPENDENCY$

Line 725: from sys.dependency$

721: cursor cur_depend(n_object_id IN dba_objects.object_id%type)
722: is select d_obj# object_id
723: , etrm_pnav.get_object_name(d_obj#, 'USER') owner
724: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item
725: from sys.dependency$
726: where p_obj# = n_object_id
727: order by etrm_pnav.get_object_name(d_obj#);
728: --
729: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)

Line 733: from sys.dependency$

729: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)
730: is select p_obj# object_id
731: , etrm_pnav.get_object_name(p_obj#, 'USER') owner
732: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item
733: from sys.dependency$
734: where d_obj# = n_object_id
735: order by etrm_pnav.get_object_name(p_obj#);
736:
737: v_first boolean;

Line 1018: from sys.dependency$

1014: , etrm_pnav.get_object_name(d_obj#, 'TYPE')) owner
1015: , etrm_pnav.get_object_name(d_obj#, 'ITEM') d_item
1016: , etrm_pnav.get_object_name(d_obj#, 'TYPE') d_item_type
1017: , etrm_pnav.get_object_name(d_obj#, 'USER') d_schema
1018: from sys.dependency$
1019: where p_obj# = n_object_id
1020: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
1021: , etrm_pnav.get_object_name(d_obj#, 'TYPE'))
1022: , etrm_pnav.get_object_name(d_obj#, 'USER')

Line 1032: from sys.dependency$

1028: , etrm_pnav.get_object_name(p_obj#, 'TYPE')) owner
1029: , etrm_pnav.get_object_name(p_obj#, 'ITEM') d_item
1030: , etrm_pnav.get_object_name(p_obj#, 'TYPE') d_item_type
1031: , etrm_pnav.get_object_name(p_obj#, 'USER') d_schema
1032: from sys.dependency$
1033: where d_obj# = n_object_id
1034: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
1035: , etrm_pnav.get_object_name(p_obj#, 'TYPE'))
1036: , etrm_pnav.get_object_name(p_obj#, 'USER')