eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TTY_NACCT_SALES_PUB dependencies on JTF_RS_REP_MANAGERS

Line 121: FROM jtf_rs_rep_managers mgr,

117:
118: -- LIST OF ALL GROUPS A GIVEN RESOURCE OWNS IN THE CONTEXT OF A PARENT GRUOP
119: cursor c_rsc_owned_grps(cl_parent_resource_id number, cl_group_id number) is
120: SELECT mgr.resource_id, mgr.group_id
121: FROM jtf_rs_rep_managers mgr,
122: jtf_rs_groups_denorm gd
123: WHERE mgr.hierarchy_type = 'MGR_TO_MGR'
124: AND mgr.resource_id = mgr.parent_resource_id
125: AND trunc(sysdate) BETWEEN mgr.start_date_active

Line 137: FROM JTF_RS_REP_MANAGERS

133: -- LIST OF ALL DIRECTS TO REMOVE WHEN REMOVING A MANAGING RESOURCE
134: -- FROM A NAMED ACCOUNT IN THE CONTEXT OF A GROUP
135: cursor c_rsc_directs(cl_parent_resource_id number, cl_group_id number) is
136: SELECT DISTINCT RESOURCE_ID
137: FROM JTF_RS_REP_MANAGERS
138: WHERE group_id = cl_group_id
139: and resource_id <> cl_parent_resource_id
140: and parent_resource_id = cl_parent_resource_id;
141: