APPS.AS_GAR_LEADS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 380: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,

376: TRES.category resource_category,
377: MIN(TRES.source_id) person_id
378: FROM jtf_rs_team_members TM, jtf_rs_teams_b T,
379: jtf_rs_team_usages TU, jtf_rs_role_relations TRR,
380: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
381: (
382: SELECT m.group_id group_id, m.resource_id resource_id
383: FROM jtf_rs_group_members m,
384: jtf_rs_groups_b g,

Line 388: jtf_rs_resource_extns res

384: jtf_rs_groups_b g,
385: jtf_rs_group_usages u,
386: jtf_rs_role_relations rr,
387: jtf_rs_roles_b r,
388: jtf_rs_resource_extns res
389: WHERE m.group_id = g.group_id
390: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
391: AND NVL(g.end_date_active,SYSDATE)
392: AND u.group_id = g.group_id

Line 436: jtf_rs_roles_b r, jtf_rs_resource_extns res,

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

Line 442: jtf_rs_roles_b tr, jtf_rs_resource_extns tres

438: SELECT tm.team_resource_id group_id,
439: t.team_id team_id
440: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,
441: jtf_rs_team_usages tu,jtf_rs_role_relations trr,
442: jtf_rs_roles_b tr, jtf_rs_resource_extns tres
443: WHERE tm.team_id = t.team_id
444: AND SYSDATE BETWEEN NVL(t.start_date_active,SYSDATE)
445: AND NVL(t.end_date_active,SYSDATE)
446: AND tu.team_id = t.team_id

Line 643: jtf_rs_roles_b r, jtf_rs_resource_extns res

639: res.category resource_category,
640: m.group_id group_id, MIN(res.source_id) person_id
641: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
642: jtf_rs_group_usages u, jtf_rs_role_relations rr,
643: jtf_rs_roles_b r, jtf_rs_resource_extns res
644: WHERE m.group_id = g.group_id
645: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
646: AND NVL(g.end_date_active,SYSDATE)
647: AND u.group_id = g.group_id