APPS.AS_GAR_LEADS_PUB dependencies on JTF_RS_GROUPS_B

Line 425: jtf_rs_groups_b g,

421: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
422: (
423: SELECT m.group_id group_id, m.resource_id resource_id
424: FROM jtf_rs_group_members m,
425: jtf_rs_groups_b g,
426: jtf_rs_group_usages u,
427: jtf_rs_role_relations rr,
428: jtf_rs_roles_b r,
429: jtf_rs_resource_extns res

Line 475: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

471: SELECT MIN(m.resource_id) resource_id,
472: MIN(m.person_id) person_id2, MIN(m.group_id) group_id,
473: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
474: MIN(res.source_id) person_id
475: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
476: jtf_rs_group_usages u, jtf_rs_role_relations rr,
477: jtf_rs_roles_b r, jtf_rs_resource_extns res,
478: (
479: SELECT tm.team_resource_id group_id,

Line 682: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

678: (
679: SELECT MIN(m.resource_id) resource_id,
680: res.category resource_category,
681: m.group_id group_id, MIN(res.source_id) person_id
682: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
683: jtf_rs_group_usages u, jtf_rs_role_relations rr,
684: jtf_rs_roles_b r, jtf_rs_resource_extns res
685: WHERE m.group_id = g.group_id
686: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)

Line 2020: JTF_RS_GROUPS_B grp

2016: FROM JTF_RS_GROUP_MEMBERS mem,
2017: JTF_RS_ROLE_RELATIONS rrel,
2018: JTF_RS_ROLES_B role,
2019: JTF_RS_GROUP_USAGES u,
2020: JTF_RS_GROUPS_B grp
2021: WHERE mem.group_member_id = rrel.role_resource_id
2022: AND rrel.role_resource_type = 'RS_GROUP_MEMBER'
2023: AND rrel.role_id = role.role_id
2024: AND role.role_type_code IN ('SALES','TELESALES','FIELDSALES','PRM')