APPS.AS_GAR_ACCOUNTS_PUB dependencies on JTF_RS_GROUPS_B

Line 428: jtf_rs_groups_b g,

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

Line 478: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

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

Line 687: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

683: (
684: SELECT MIN(m.resource_id) resource_id,
685: res.CATEGORY resource_category,
686: m.group_id group_id, MIN(res.source_id) person_id
687: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
688: jtf_rs_group_usages u, jtf_rs_role_relations rr,
689: jtf_rs_roles_b r, jtf_rs_resource_extns res
690: WHERE m.group_id = g.group_id
691: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)