APPS.AS_GAR_PROPOSALS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 358: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,

354: TRES.category resource_category,
355: TRES.source_id person_id
356: FROM jtf_rs_team_members TM, jtf_rs_teams_b T,
357: jtf_rs_team_usages TU, jtf_rs_role_relations TRR,
358: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
359: (
360: SELECT m.group_id group_id, m.resource_id resource_id
361: FROM jtf_rs_group_members m,
362: jtf_rs_groups_b g,

Line 366: jtf_rs_resource_extns res

362: jtf_rs_groups_b g,
363: jtf_rs_group_usages u,
364: jtf_rs_role_relations rr,
365: jtf_rs_roles_b r,
366: jtf_rs_resource_extns res
367: WHERE m.group_id = g.group_id
368: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
369: AND NVL(g.end_date_active,SYSDATE)
370: AND u.group_id = g.group_id

Line 414: jtf_rs_roles_b r, jtf_rs_resource_extns res,

410: MIN(jtm.team_id) team_id, res.category resource_category,
411: MIN(res.source_id) person_id
412: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
413: jtf_rs_group_usages u, jtf_rs_role_relations rr,
414: jtf_rs_roles_b r, jtf_rs_resource_extns res,
415: (
416: SELECT tm.team_resource_id group_id,
417: t.team_id team_id
418: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,

Line 420: jtf_rs_roles_b tr, jtf_rs_resource_extns tres

416: SELECT tm.team_resource_id group_id,
417: t.team_id team_id
418: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,
419: jtf_rs_team_usages tu,jtf_rs_role_relations trr,
420: jtf_rs_roles_b tr, jtf_rs_resource_extns tres
421: WHERE tm.team_id = t.team_id
422: AND SYSDATE BETWEEN NVL(t.start_date_active,SYSDATE)
423: AND NVL(t.end_date_active,SYSDATE)
424: AND tu.team_id = t.team_id

Line 623: jtf_rs_roles_b r, jtf_rs_resource_extns res

619: res.CATEGORY resource_category,
620: m.group_id group_id, MIN(res.source_id) person_id
621: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
622: jtf_rs_group_usages u, jtf_rs_role_relations rr,
623: jtf_rs_roles_b r, jtf_rs_resource_extns res
624: WHERE m.group_id = g.group_id
625: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
626: AND NVL(g.end_date_active,SYSDATE)
627: AND u.group_id = g.group_id