APPS.AS_RTTAP_ACCOUNT dependencies on JTF_RS_GROUPS_B

Line 602: jtf_rs_groups_b g,

598: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
599: (
600: SELECT m.group_id group_id, m.resource_id resource_id
601: FROM jtf_rs_group_members m,
602: jtf_rs_groups_b g,
603: jtf_rs_group_usages u,
604: jtf_rs_role_relations rr,
605: jtf_rs_roles_b r,
606: jtf_rs_resource_extns res

Line 652: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

648: SELECT MIN(m.resource_id) resource_id,
649: MIN(m.person_id) person_id2, MIN(m.group_id) group_id,
650: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
651: MIN(res.source_id) person_id
652: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
653: jtf_rs_group_usages u, jtf_rs_role_relations rr,
654: jtf_rs_roles_b r, jtf_rs_resource_extns res,
655: (
656: SELECT tm.team_resource_id group_id,

Line 790: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

786: (
787: SELECT min(m.resource_id) resource_id,
788: res.category resource_category,
789: m.group_id group_id, min(res.source_id) person_id
790: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
791: jtf_rs_group_usages u, jtf_rs_role_relations rr,
792: jtf_rs_roles_b r, jtf_rs_resource_extns res
793: WHERE m.group_id = g.group_id
794: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)