APPS.AS_GAR_OPPTYS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 385: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,

381: TRES.CATEGORY resource_category,
382: MIN(TRES.source_id) person_id
383: FROM jtf_rs_team_members TM, jtf_rs_teams_b T,
384: jtf_rs_team_usages TU, jtf_rs_role_relations TRR,
385: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
386: (
387: SELECT m.group_id group_id, m.resource_id resource_id
388: FROM jtf_rs_group_members m,
389: jtf_rs_groups_b g,

Line 393: jtf_rs_resource_extns res

389: jtf_rs_groups_b g,
390: jtf_rs_group_usages u,
391: jtf_rs_role_relations rr,
392: jtf_rs_roles_b r,
393: jtf_rs_resource_extns res
394: WHERE m.group_id = g.group_id
395: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
396: AND NVL(g.end_date_active,SYSDATE)
397: AND u.group_id = g.group_id

Line 441: jtf_rs_roles_b r, jtf_rs_resource_extns res,

437: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
438: MIN(res.source_id) person_id
439: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
440: jtf_rs_group_usages u, jtf_rs_role_relations rr,
441: jtf_rs_roles_b r, jtf_rs_resource_extns res,
442: (
443: SELECT tm.team_resource_id group_id,
444: t.team_id team_id
445: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,

Line 447: jtf_rs_roles_b tr, jtf_rs_resource_extns tres

443: SELECT tm.team_resource_id group_id,
444: t.team_id team_id
445: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,
446: jtf_rs_team_usages tu,jtf_rs_role_relations trr,
447: jtf_rs_roles_b tr, jtf_rs_resource_extns tres
448: WHERE tm.team_id = t.team_id
449: AND SYSDATE BETWEEN NVL(t.start_date_active,SYSDATE)
450: AND NVL(t.end_date_active,SYSDATE)
451: AND tu.team_id = t.team_id

Line 648: jtf_rs_roles_b r, jtf_rs_resource_extns res

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)
651: AND NVL(g.end_date_active,SYSDATE)
652: AND u.group_id = g.group_id