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.CN_GET_SRP_DATA_PVT dependencies on CN_QM_MGR_SRP_GROUPS

Line 196: from cn_qm_mgr_srp_groups

192:
193: cursor get_srp_group_info is
194: select manager_flag, start_date_active,
195: nvl(end_date_active, g_end_of_time) end_date_active
196: from cn_qm_mgr_srp_groups
197: where srp_id = p_srp_id and comp_group_id = p_comp_group_id;
198:
199: cursor get_group_members (l_comp_group_id in number) is
200: select sg.role_id, sg.role_name, sg.start_date_active, sg.group_name,

Line 204: from cn_qm_mgr_srp_groups sg, cn_srp_hr_data sd

200: select sg.role_id, sg.role_name, sg.start_date_active, sg.group_name,
201: nvl(sg.end_date_active, g_end_of_time) end_date_active,
202: sg.srp_id, sd.name srp_name, sd.emp_num, sg.manager_flag,
203: decode(sg.manager_flag, 'Y', sd.name || ' *', sd.name) ast_name
204: from cn_qm_mgr_srp_groups sg, cn_srp_hr_data sd
205: where sg.comp_group_id = l_comp_group_id and sg.srp_id = sd.srp_id;
206:
207: cursor get_parent_groups is
208: select parent_comp_group_id, start_date_active,