APPS.PRP_RTTAP_INT_PVT dependencies on JTF_RS_GROUPS_B

Line 322: jtf_rs_groups_b g,

318: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
319: (
320: SELECT m.group_id group_id, m.resource_id resource_id
321: FROM jtf_rs_group_members m,
322: jtf_rs_groups_b g,
323: jtf_rs_group_usages u,
324: jtf_rs_role_relations rr,
325: jtf_rs_roles_b r,
326: jtf_rs_resource_extns res

Line 372: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

368: SELECT MIN(m.resource_id) resource_id,
369: MIN(m.person_id) person_id2, MIN(m.group_id) group_id,
370: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
371: MIN(res.source_id) person_id
372: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
373: jtf_rs_group_usages u, jtf_rs_role_relations rr,
374: jtf_rs_roles_b r, jtf_rs_resource_extns res,
375: (
376: SELECT tm.team_resource_id group_id,

Line 507: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

503: (
504: SELECT min(m.resource_id) resource_id,
505: res.category resource_category,
506: m.group_id group_id, min(res.source_id) person_id
507: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
508: jtf_rs_group_usages u, jtf_rs_role_relations rr,
509: jtf_rs_roles_b r, jtf_rs_resource_extns res
510: WHERE m.group_id = g.group_id
511: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)