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_MGR_SRP_GROUPS

Line 744: FROM cn_qm_mgr_srp_groups

740:
741: CURSOR members_csr(p_group_id NUMBER) IS
742: SELECT srp_id salesrep_id, role_id, comp_group_id,
743: trunc(start_date_active) start_date, trunc(end_date_active) end_date
744: FROM cn_qm_mgr_srp_groups
745: WHERE comp_group_id = p_group_id;
746:
747: BEGIN
748: -- Standard Start of API savepoint

Line 967: FROM cn_qm_mgr_srp_groups

963:
964: CURSOR members_csr(p_group_id NUMBER) IS
965: SELECT srp_id salesrep_id, trunc(start_date_active) start_date,
966: trunc(end_date_active) end_date, role_id, comp_group_id, manager_flag
967: FROM cn_qm_mgr_srp_groups
968: WHERE comp_group_id = p_group_id
969: ORDER BY manager_flag DESC;
970:
971: CURSOR mgr_check IS

Line 1809: FROM cn_qm_mgr_srp_groups g,

1805: CURSOR members_csr(p_group_id NUMBER) IS
1806: SELECT srd.srp_role_id, srd.srp_id, job_title_id, overlay_flag, non_std_flag, srd.role_id role_id,
1807: g.role_name role_name, job_discretion, status, plan_activate_status, club_eligible_flag,
1808: org_code, trunc(start_date) start_date, trunc(end_date) end_date, g.comp_group_id group_id
1809: FROM cn_qm_mgr_srp_groups g,
1810: cn_srp_role_dtls_v srd
1811: WHERE g.comp_group_id = p_group_id
1812: AND g.srp_role_id = srd.srp_role_id
1813: AND (trunc(srd.start_date) <= p_srp.effective_date)

Line 2029: FROM cn_qm_mgr_srp_groups g,

2025: CURSOR members_csr(p_group_id NUMBER) IS
2026: SELECT srd.srp_role_id, srd.srp_id, job_title_id, overlay_flag, non_std_flag, srd.role_id role_id,
2027: g.role_name role_name, job_discretion, status, plan_activate_status, club_eligible_flag,
2028: org_code, trunc(start_date) start_date, trunc(end_date) end_date, g.comp_group_id group_id
2029: FROM cn_qm_mgr_srp_groups g,
2030: cn_srp_role_dtls_v srd
2031: WHERE g.comp_group_id = p_group_id
2032: AND g.srp_role_id = srd.srp_role_id
2033: AND (trunc(srd.start_date) <= p_srp.effective_date)

Line 2048: -- COLLAPSED cn_qm_mgr_srp_groups

2044: AND manager_srp_id = p_srp.salesrep_id
2045: AND (trunc(start_date_active) <= p_srp.effective_date)
2046: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);
2047:
2048: -- COLLAPSED cn_qm_mgr_srp_groups
2049: CURSOR mo_members_csr(p_group_id NUMBER) IS
2050: SELECT srdd.srp_role_id, srdd.srp_id, srdd.job_title_id, srdd.overlay_flag, srdd.non_std_flag,
2051: srdd.role_id role_id,srdd.job_discretion, srdd.status, srdd.plan_activate_status, srdd.club_eligible_flag,
2052: srdd.org_code,trunc(srdd.start_date) start_date, trunc(srdd.end_date) end_date,

Line 2083: -- COLLAPSED cn_qm_mgr_srp_groups

2079: AND (jgm.end_date_active IS NULL OR trunc(jgm.end_date_active) >= p_srp.effective_date)
2080: AND srdd.job_title_id <> -99
2081: ORDER BY jgm.manager_flag DESC;
2082:
2083: -- COLLAPSED cn_qm_mgr_srp_groups
2084: CURSOR mo_mgr_check IS
2085: SELECT jgm.manager_flag manager_flag
2086: FROM
2087: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,

Line 2232: FROM cn_qm_mgr_srp_groups g,

2228: ELSE
2229: OPEN members_csr_rc FOR SELECT srd.srp_role_id, srd.srp_id, job_title_id, overlay_flag, non_std_flag, srd.role_id role_id,
2230: g.role_name role_name, job_discretion, status, plan_activate_status, club_eligible_flag,
2231: org_code, trunc(start_date) start_date, trunc(end_date) end_date, g.comp_group_id group_id
2232: FROM cn_qm_mgr_srp_groups g,
2233: cn_srp_role_dtls_v srd
2234: WHERE g.comp_group_id = p_srp.group_id
2235: AND g.srp_role_id = srd.srp_role_id
2236: AND (trunc(srd.start_date) <= p_srp.effective_date)

Line 2345: FROM cn_qm_mgr_srp_groups g,

2341: ELSE
2342: OPEN members_csr_rc FOR SELECT srd.srp_role_id, srd.srp_id, job_title_id, overlay_flag, non_std_flag, srd.role_id role_id,
2343: g.role_name role_name, job_discretion, status, plan_activate_status, club_eligible_flag,
2344: org_code, trunc(start_date) start_date, trunc(end_date) end_date, g.comp_group_id group_id
2345: FROM cn_qm_mgr_srp_groups g,
2346: cn_srp_role_dtls_v srd
2347: WHERE g.comp_group_id = l_descendant_group(eachgroup).group_id
2348: AND g.srp_role_id = srd.srp_role_id
2349: AND (trunc(srd.start_date) <= p_srp.effective_date)