APPS.ASO_SALES_TEAM_PVT dependencies on JTF_RS_GROUPS_B

Line 141: jtf_rs_groups_b g,

137: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
138: (
139: SELECT m.group_id group_id, m.resource_id resource_id
140: FROM jtf_rs_group_members m,
141: jtf_rs_groups_b g,
142: jtf_rs_group_usages u,
143: jtf_rs_role_relations rr,
144: jtf_rs_roles_b r,
145: jtf_rs_resource_extns res

Line 191: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

187: SELECT MIN(m.resource_id) resource_id,
188: MIN(m.person_id) person_id2, MIN(m.group_id) group_id,
189: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
190: MIN(res.source_id) person_id
191: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
192: jtf_rs_group_usages u, jtf_rs_role_relations rr,
193: jtf_rs_roles_b r, jtf_rs_resource_extns res,
194: (
195: SELECT tm.team_resource_id group_id,

Line 1775: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

1771: (
1772: SELECT min(m.resource_id) resource_id,
1773: res.category resource_category,
1774: m.group_id group_id, min(res.source_id) person_id
1775: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
1776: jtf_rs_group_usages u, jtf_rs_role_relations rr,
1777: jtf_rs_roles_b r, jtf_rs_resource_extns res
1778: WHERE m.group_id = g.group_id
1779: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)