APPS.AS_GAR_QOT_PUB dependencies on JTF_RS_GROUPS_B

Line 386: jtf_rs_groups_b g,

382: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
383: (
384: SELECT m.group_id group_id, m.resource_id resource_id
385: FROM jtf_rs_group_members m,
386: jtf_rs_groups_b g,
387: jtf_rs_group_usages u,
388: jtf_rs_role_relations rr,
389: jtf_rs_roles_b r,
390: jtf_rs_resource_extns res

Line 436: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

432: SELECT MIN(m.resource_id) resource_id,
433: MIN(m.person_id) person_id2, MIN(m.group_id) group_id,
434: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
435: MIN(res.source_id) person_id
436: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
437: jtf_rs_group_usages u, jtf_rs_role_relations rr,
438: jtf_rs_roles_b r, jtf_rs_resource_extns res,
439: (
440: SELECT tm.team_resource_id group_id,

Line 646: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

642: (
643: SELECT MIN(m.resource_id) resource_id,
644: res.CATEGORY resource_category,
645: m.group_id group_id, MIN(res.source_id) person_id
646: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
647: jtf_rs_group_usages u, jtf_rs_role_relations rr,
648: jtf_rs_roles_b r, jtf_rs_resource_extns res
649: WHERE m.group_id = g.group_id
650: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)