APPS.CN_SRP_HIER_PROC_PVT dependencies on CN_SRP_ROLE_DTLS_V

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 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)