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_GROUPS

Line 382: FROM cn_qm_mgr_groups

378:
379: CURSOR l_mgr_role_id_csr IS
380: SELECT manager_srp_id, comp_group_id, trunc(start_date_active) start_date_active,
381: trunc(end_date_active) end_date_active, role_id
382: FROM cn_qm_mgr_groups
383: WHERE comp_group_id = l_comp_group_id;
384:
385: CURSOR l_parent_grp_srp_csr IS
386: SELECT srp_id, comp_group_id, trunc(start_date_active) start_date_active,

Line 393: FROM cn_qm_mgr_groups

389: WHERE comp_group_id = l_comp_group_id;
390:
391: CURSOR l_mgr_group_csr is
392: SELECT 1
393: FROM cn_qm_mgr_groups
394: WHERE manager_srp_id = p_salesrep_id;
395:
396: CURSOR l_parent_group_csr is
397: SELECT parent_comp_group_id

Line 579: FROM cn_qm_mgr_groups

575:
576: CURSOR l_mgr_role_id_csr IS
577: SELECT srp_role_id, comp_group_id, trunc(start_date_active) start_date_active,
578: trunc(end_date_active) end_date_active, role_id, manager_srp_id
579: FROM cn_qm_mgr_groups
580: WHERE manager_srp_id = p_salesrep_id
581: AND comp_group_id = p_comp_group_id;
582:
583: CURSOR l_srp_role_id_csr IS

Line 736: FROM cn_qm_mgr_groups

732: CURSOR managers_csr(p_group_id NUMBER) IS
733: SELECT manager_srp_id salesrep_id, role_id ,comp_group_id,
734: trunc(start_date_active) start_date_active,
735: trunc(end_date_active) end_date_active
736: FROM cn_qm_mgr_groups
737: WHERE comp_group_id = p_group_id
738: AND manager_srp_id <> p_srp.salesrep_id
739: AND manager_flag = 'Y';
740:

Line 973: FROM cn_qm_mgr_groups

969: ORDER BY manager_flag DESC;
970:
971: CURSOR mgr_check IS
972: SELECT manager_flag
973: FROM cn_qm_mgr_groups
974: WHERE comp_group_id = p_srp.group_id
975: AND manager_srp_id = p_srp.salesrep_id
976: AND (trunc(start_date_active) <= p_srp.effective_date)
977: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);

Line 1224: FROM cn_qm_mgr_groups

1220: ;
1221:
1222: CURSOR grp_mgr(p_group_id NUMBER) IS
1223: SELECT NVL(MAX(manager_srp_id),0) -- will return null if grp has no manager
1224: FROM cn_qm_mgr_groups
1225: WHERE comp_group_id = p_group_id
1226: AND (trunc(start_date_active) <= p_srp.effective_date)
1227: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);
1228:

Line 1231: FROM cn_qm_mgr_groups

1227: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);
1228:
1229: CURSOR mgr_check IS
1230: SELECT manager_flag
1231: FROM cn_qm_mgr_groups
1232: WHERE comp_group_id = p_srp.group_id
1233: AND manager_srp_id = p_srp.salesrep_id
1234: AND (trunc(start_date_active) <= p_srp.effective_date)
1235: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);

Line 1451: FROM cn_qm_mgr_groups

1447: ;
1448:
1449: CURSOR grp_mgr(p_group_id NUMBER) IS
1450: SELECT NVL(MAX(manager_srp_id),0) -- will return null if grp has no manager
1451: FROM cn_qm_mgr_groups
1452: WHERE comp_group_id = p_group_id
1453: AND (trunc(start_date_active) <= p_srp.effective_date)
1454: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);
1455:

Line 1458: FROM cn_qm_mgr_groups

1454: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);
1455:
1456: CURSOR mgr_check IS
1457: SELECT manager_flag
1458: FROM cn_qm_mgr_groups
1459: WHERE comp_group_id = p_srp.group_id
1460: AND manager_srp_id = p_srp.salesrep_id
1461: AND (trunc(start_date_active) <= p_srp.effective_date)
1462: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);

Line 1581: FROM cn_qm_mgr_groups

1577: AND (trunc(jgm.start_date_active) <= p_srp.effective_date)
1578: AND (jgm.end_date_active IS NULL OR trunc(jgm.end_date_active) >= p_srp.effective_date);
1579: ELSE
1580: OPEN mgr_check_rc FOR SELECT manager_flag
1581: FROM cn_qm_mgr_groups
1582: WHERE comp_group_id = p_srp.group_id
1583: AND manager_srp_id = p_srp.salesrep_id
1584: AND (trunc(start_date_active) <= p_srp.effective_date)
1585: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);

Line 1645: FROM cn_qm_mgr_groups

1641: AND (trunc(jgm.start_date_active) <= p_srp.effective_date)
1642: AND (jgm.end_date_active IS NULL OR trunc(jgm.end_date_active) >= p_srp.effective_date);
1643: ELSE
1644: OPEN grp_mgr_rc FOR SELECT NVL(MAX(manager_srp_id),0)
1645: FROM cn_qm_mgr_groups
1646: WHERE comp_group_id = eachgroup.group_id
1647: AND (trunc(start_date_active) <= p_srp.effective_date)
1648: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);
1649: END IF;

Line 1822: FROM cn_qm_mgr_groups

1818: ORDER BY g.manager_flag DESC;
1819:
1820: CURSOR mgr_check IS
1821: SELECT manager_flag
1822: FROM cn_qm_mgr_groups
1823: WHERE comp_group_id = p_srp.group_id
1824: AND manager_srp_id = p_srp.salesrep_id
1825: AND (trunc(start_date_active) <= p_srp.effective_date)
1826: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);

Line 2042: FROM cn_qm_mgr_groups

2038: ORDER BY g.manager_flag DESC;
2039:
2040: CURSOR mgr_check IS
2041: SELECT manager_flag
2042: FROM cn_qm_mgr_groups
2043: WHERE comp_group_id = p_srp.group_id
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);

Line 2178: FROM cn_qm_mgr_groups

2174: AND (trunc(jgm.start_date_active) <= p_srp.effective_date)
2175: AND (jgm.end_date_active IS NULL OR trunc(jgm.end_date_active) >= p_srp.effective_date);
2176: ELSE
2177: OPEN mgr_check_rc FOR SELECT manager_flag
2178: FROM cn_qm_mgr_groups
2179: WHERE comp_group_id = p_srp.group_id
2180: AND manager_srp_id = p_srp.salesrep_id
2181: AND (trunc(start_date_active) <= p_srp.effective_date)
2182: AND (end_date_active IS NULL OR trunc(end_date_active) >= p_srp.effective_date);

Line 2486: FROM cn_qm_mgr_groups

2482: l_returned_rows number;
2483:
2484: CURSOR l_mgr_group_csr is
2485: SELECT 1
2486: FROM cn_qm_mgr_groups
2487: WHERE manager_srp_id = p_srp.salesrep_id;
2488:
2489: CURSOR l_parent_group_csr(p_group_id NUMBER) is
2490: SELECT parent_comp_group_id

Line 2501: FROM cn_qm_mgr_groups

2497: CURSOR managers_csr(p_group_id NUMBER) IS
2498: SELECT manager_srp_id salesrep_id, role_id ,comp_group_id,
2499: trunc(start_date_active) start_date_active,
2500: trunc(end_date_active) end_date_active
2501: FROM cn_qm_mgr_groups
2502: WHERE comp_group_id = p_group_id
2503: AND manager_srp_id <> p_srp.salesrep_id
2504: AND manager_flag = 'Y';
2505: