DBA Data[Home] [Help]

APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_RS_REP_MANAGERS

Line 1711: FROM jtf_rs_rep_managers mgr,

1707:
1708: -- LIST OF ALL GROUPS A GIVEN RESOURCE OWNS IN THE CONTEXT OF A PARENT GRUOP
1709: cursor c_rsc_owned_grps(cl_parent_resource_id number, cl_group_id number) is
1710: SELECT mgr.resource_id, mgr.group_id
1711: FROM jtf_rs_rep_managers mgr,
1712: jtf_rs_groups_denorm gd
1713: WHERE mgr.hierarchy_type = 'MGR_TO_MGR'
1714: AND mgr.resource_id = mgr.parent_resource_id
1715: AND trunc(sysdate) BETWEEN mgr.start_date_active

Line 1727: FROM JTF_RS_REP_MANAGERS

1723: -- LIST OF ALL DIRECTS TO REMOVE WHEN REMOVING A MANAGING RESOURCE
1724: -- FROM A NAMED ACCOUNT IN THE CONTEXT OF A GROUP
1725: cursor c_rsc_directs(cl_parent_resource_id number, cl_group_id number) is
1726: SELECT DISTINCT RESOURCE_ID
1727: FROM JTF_RS_REP_MANAGERS
1728: WHERE group_id = cl_group_id
1729: and resource_id <> cl_parent_resource_id
1730: and parent_resource_id = cl_parent_resource_id;
1731: