APPS.JTF_RS_ROLE_RELATE_VUHK dependencies on JTF_RS_GROUP_USAGES

Line 1027: FROM jtf_rs_group_usages u,

1023:
1024: -- cursor to get the information about this role relation (single-org)
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

Line 1047: FROM jtf_rs_group_usages u,

1043: ct.comp_team_id team_id,
1044: greatest(r.start_date_active, ct.start_date_active) start_date,
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,

Line 1463: FROM jtf_rs_group_usages u,

1459: ct.comp_team_id team_id,
1460: greatest(l_start_date, ct.start_date_active) start_date,
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,

Line 1886: FROM jtf_rs_group_usages u,

1882: -- cursor to get the information about this role relation (single-org)
1883: CURSOR role_relate_info IS
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

Line 1901: FROM jtf_rs_group_usages u,

1897: SELECT ct.name name,
1898: ct.comp_team_id team_id,
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,

Line 2230: FROM jtf_rs_group_usages u,

2226: -- cursor to get the information about this role relation
2227: CURSOR role_relate_info IS
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

Line 2247: FROM jtf_rs_group_usages u,

2243: SELECT ct.name name,
2244: ct.comp_team_id team_id,
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,