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_SRP_HIER_PROC_PVT dependencies on CN_QM_SRP_GROUPS

Line 375: FROM cn_qm_srp_groups

371:
372: CURSOR l_srp_role_id_csr IS
373: SELECT srp_role_id, comp_group_id, trunc(start_date_active) start_date_active,
374: trunc(end_date_active) end_date_active
375: FROM cn_qm_srp_groups
376: WHERE srp_id = p_salesrep_id
377: AND manager_flag = 'N';
378:
379: CURSOR l_mgr_role_id_csr IS

Line 388: FROM cn_qm_srp_groups

384:
385: CURSOR l_parent_grp_srp_csr IS
386: SELECT srp_id, comp_group_id, trunc(start_date_active) start_date_active,
387: trunc(end_date_active) end_date_active, role_id
388: FROM cn_qm_srp_groups
389: WHERE comp_group_id = l_comp_group_id;
390:
391: CURSOR l_mgr_group_csr is
392: SELECT 1

Line 586: FROM cn_qm_srp_groups

582:
583: CURSOR l_srp_role_id_csr IS
584: SELECT srp_id, comp_group_id, trunc(start_date_active) start_date_active,
585: trunc(end_date_active) end_date_active, role_id
586: FROM cn_qm_srp_groups
587: WHERE comp_group_id = l_comp_group_id;
588:
589: BEGIN
590: -- Standard Start of API savepoint