APPS.AS_RTTAP_OPPTY dependencies on JTF_RS_GROUPS_B

Line 404: jtf_rs_groups_b g,

400: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
401: (
402: SELECT m.group_id group_id, m.resource_id resource_id
403: FROM jtf_rs_group_members m,
404: jtf_rs_groups_b g,
405: jtf_rs_group_usages u,
406: jtf_rs_role_relations rr,
407: jtf_rs_roles_b r,
408: jtf_rs_resource_extns res

Line 454: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

450: SELECT MIN(m.resource_id) resource_id,
451: MIN(m.person_id) person_id2, MIN(m.group_id) group_id,
452: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
453: MIN(res.source_id) person_id
454: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
455: jtf_rs_group_usages u, jtf_rs_role_relations rr,
456: jtf_rs_roles_b r, jtf_rs_resource_extns res,
457: (
458: SELECT tm.team_resource_id group_id,

Line 588: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

584: (
585: SELECT min(m.resource_id) resource_id,
586: res.category resource_category,
587: m.group_id group_id, min(res.source_id) person_id
588: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
589: jtf_rs_group_usages u, jtf_rs_role_relations rr,
590: jtf_rs_roles_b r, jtf_rs_resource_extns res
591: WHERE m.group_id = g.group_id
592: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)