DBA Data[Home] [Help]

APPS.ETRM_PNAV dependencies on DEPENDENCY$

Line 1588: from sys.dependency$

1584: cursor cur_depend(n_object_id IN dba_objects.object_id%type)
1585: is select d_obj# object_id
1586: , etrm_pnav.get_object_name(d_obj#, 'USER') owner
1587: , etrm_pnav.get_object_name(d_obj#, 'ITEM') item
1588: from sys.dependency$
1589: where p_obj# = n_object_id
1590: order by etrm_pnav.get_object_name(d_obj#);
1591: --
1592: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)

Line 1596: from sys.dependency$

1592: cursor cur_depend2(n_object_id IN dba_objects.object_id%type)
1593: is select p_obj# object_id
1594: , etrm_pnav.get_object_name(p_obj#, 'USER') owner
1595: , etrm_pnav.get_object_name(p_obj#, 'ITEM') item
1596: from sys.dependency$
1597: where d_obj# = n_object_id
1598: order by etrm_pnav.get_object_name(p_obj#);
1599:
1600: v_first boolean;