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_SRP_ROLE_DTLS

Line 1471: cn_srp_role_dtls srd

1467: SELECT NVL(MAX(jrs.salesrep_id),0) manager_srp_id
1468: FROM
1469: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
1470: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
1471: cn_srp_role_dtls srd
1472: WHERE
1473: jg.group_id = jgm.group_id
1474: and jgm.manager_flag = 'Y'
1475: and jrs.resource_id = jgm.resource_id

Line 1497: cn_srp_role_dtls srd

1493: SELECT jgm.manager_flag manager_flag
1494: FROM
1495: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
1496: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
1497: cn_srp_role_dtls srd
1498: WHERE
1499: jg.group_id = jgm.group_id
1500: and jgm.manager_flag = 'Y'
1501: and jrs.resource_id = jgm.resource_id

Line 1558: cn_srp_role_dtls srd

1554: OPEN mgr_check_rc FOR SELECT jgm.manager_flag manager_flag
1555: FROM
1556: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
1557: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
1558: cn_srp_role_dtls srd
1559: WHERE
1560: jg.group_id = jgm.group_id
1561: and jgm.manager_flag = 'Y'
1562: and jrs.resource_id = jgm.resource_id

Line 1623: cn_srp_role_dtls srd

1619: OPEN grp_mgr_rc FOR SELECT NVL(MAX(jrs.salesrep_id),0) manager_srp_id
1620: FROM
1621: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
1622: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
1623: cn_srp_role_dtls srd
1624: WHERE
1625: jg.group_id = jgm.group_id
1626: and jgm.manager_flag = 'Y'
1627: and jrs.resource_id = jgm.resource_id

Line 1810: cn_srp_role_dtls_v srd

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)
1814: AND (srd.end_date IS NULL OR trunc(srd.end_date) >= p_srp.effective_date)

Line 2030: cn_srp_role_dtls_v srd

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)
2034: AND (srd.end_date IS NULL OR trunc(srd.end_date) >= p_srp.effective_date)

Line 2057: cn_srp_role_dtls_v srdd

2053: jgm.role_name role_name,jgm.group_id group_id
2054: FROM
2055: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2056: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u ,
2057: cn_srp_role_dtls_v srdd
2058: WHERE
2059: jg.group_id = jgm.group_id
2060: and (jgm.manager_flag = 'Y' or jgm.member_flag = 'Y')
2061: and jrs.resource_id = jgm.resource_id

Line 2089: cn_srp_role_dtls srd

2085: SELECT jgm.manager_flag manager_flag
2086: FROM
2087: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2088: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
2089: cn_srp_role_dtls srd
2090: WHERE
2091: jg.group_id = jgm.group_id
2092: and jgm.manager_flag = 'Y'
2093: and jrs.resource_id = jgm.resource_id

Line 2155: cn_srp_role_dtls srd

2151: SELECT jgm.manager_flag manager_flag
2152: FROM
2153: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2154: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u,
2155: cn_srp_role_dtls srd
2156: WHERE
2157: jg.group_id = jgm.group_id
2158: and jgm.manager_flag = 'Y'
2159: and jrs.resource_id = jgm.resource_id

Line 2203: cn_srp_role_dtls_v srdd

2199: jgm.group_id group_id
2200: FROM
2201: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2202: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u ,
2203: cn_srp_role_dtls_v srdd
2204: WHERE
2205: jg.group_id = jgm.group_id
2206: and (jgm.manager_flag = 'Y' or jgm.member_flag = 'Y')
2207: and jrs.resource_id = jgm.resource_id

Line 2233: cn_srp_role_dtls_v srd

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)
2237: AND (srd.end_date IS NULL OR trunc(srd.end_date) >= p_srp.effective_date)

Line 2316: cn_srp_role_dtls_v srdd

2312: jgm.group_id group_id
2313: FROM
2314: jtf_rs_groups_vl jg, jtf_rs_role_relations jrr, jtf_rs_salesreps jrs,
2315: jtf_rs_roles_b jr,jtf_rs_group_mbr_role_vl jgm, jtf_rs_group_usages u ,
2316: cn_srp_role_dtls_v srdd
2317: WHERE
2318: jg.group_id = jgm.group_id
2319: and (jgm.manager_flag = 'Y' or jgm.member_flag = 'Y')
2320: and jrs.resource_id = jgm.resource_id

Line 2346: cn_srp_role_dtls_v srd

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)
2350: AND (srd.end_date IS NULL OR trunc(srd.end_date) >= p_srp.effective_date)