APPS.ETRM_RPT dependencies on ETRM_FNDNAV

Line 1013: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')

1009: and d.object_type = 'VIEW'
1010: order by 2, 1;
1011:
1012: cursor cur_depend(n_object_id in dba_objects.object_id%type) is
1013: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
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

Line 1020: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, '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')
1023: , etrm_pnav.get_object_name(d_obj#, 'ITEM');
1024:

Line 1027: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')

1023: , etrm_pnav.get_object_name(d_obj#, 'ITEM');
1024:
1025:
1026: cursor cur_depend2(n_object_id in dba_objects.object_id%type) is
1027: select etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
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

Line 1034: order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, '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')
1037: , etrm_pnav.get_object_name(p_obj#, 'ITEM');
1038: