APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_RS_SALESREPS

Line 1029: cn_rs_salesreps s,

1025: CURSOR role_relate_info IS
1026: SELECT r.manager_flag, r.group_id, s.salesrep_id
1027: FROM jtf_rs_group_usages u,
1028: jtf_rs_group_mbr_role_vl r,
1029: cn_rs_salesreps s,
1030: jtf_rs_roles_b ro
1031: WHERE r.role_relate_id = p_role_relate_id
1032: AND u.group_id = r.group_id
1033: AND u.usage = 'SALES_COMP'

Line 1049: cn_rs_salesreps s, -- single-org view

1045: least(nvl(ct.end_date_active, l_max_date),
1046: nvl(r.end_date_active, l_max_date)) end_date
1047: FROM jtf_rs_group_usages u,
1048: jtf_rs_group_mbr_role_vl r,
1049: cn_rs_salesreps s, -- single-org view
1050: jtf_rs_roles_b ro,
1051: cn_srp_comp_teams_v srt,
1052: cn_comp_teams ct
1053: WHERE r.role_relate_id = p_role_relate_id

Line 1465: cn_rs_salesreps s,

1461: least(nvl(ct.end_date_active, l_max_date),
1462: nvl(l_end_date, l_max_date)) end_date
1463: FROM jtf_rs_group_usages u,
1464: jtf_rs_group_mbr_role_vl r,
1465: cn_rs_salesreps s,
1466: jtf_rs_roles_b ro,
1467: cn_srp_comp_teams_v srt,
1468: cn_comp_teams ct
1469: WHERE r.role_relate_id = p_role_relate_id

Line 1888: cn_rs_salesreps s

1884: SELECT r.manager_flag, r.group_id, s.salesrep_id,
1885: r.start_date_active, r.end_date_active
1886: FROM jtf_rs_group_usages u,
1887: jtf_rs_group_mbr_role_vl r,
1888: cn_rs_salesreps s
1889: WHERE r.role_relate_id = p_role_relate_id
1890: AND u.group_id = r.group_id
1891: AND u.usage = 'SALES_COMP'
1892: AND s.resource_id = r.resource_id;

Line 1903: cn_rs_salesreps s,

1899: greatest(r.start_date_active, ct.start_date_active) start_date,
1900: Least(nvl(ct.end_date_active, l_max_date), nvl(r.end_date_active, l_max_date)) end_date
1901: FROM jtf_rs_group_usages u,
1902: jtf_rs_group_mbr_role_vl r,
1903: cn_rs_salesreps s,
1904: jtf_rs_roles_b ro,
1905: cn_srp_comp_teams_v srt,
1906: cn_comp_teams ct
1907: WHERE r.role_relate_id = p_role_relate_id

Line 2232: cn_rs_salesreps s

2228: SELECT r.manager_flag, r.group_id, s.salesrep_id, s.resource_id,
2229: r.start_date_active, r.end_date_active, r.role_id
2230: FROM jtf_rs_group_usages u,
2231: jtf_rs_group_mbr_role_vl r,
2232: cn_rs_salesreps s
2233: WHERE r.role_relate_id = p_role_relate_id
2234: AND u.group_id = r.group_id
2235: AND u.usage = 'SALES_COMP'
2236: AND s.resource_id = r.resource_id;

Line 2249: cn_rs_salesreps s,

2245: greatest(l_start_date, ct.start_date_active) start_date,
2246: Least(nvl(ct.end_date_active, l_max_date), nvl(l_end_date, l_max_date)) end_date
2247: FROM jtf_rs_group_usages u,
2248: jtf_rs_group_mbr_role_vl r,
2249: cn_rs_salesreps s,
2250: jtf_rs_roles_b ro,
2251: cn_srp_comp_teams_v srt,
2252: cn_comp_teams ct
2253: WHERE r.role_relate_id = p_role_relate_id