APPS.AS_GAR_LEADS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 421: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,

417: TRES.category resource_category,
418: MIN(TRES.source_id) person_id
419: FROM jtf_rs_team_members TM, jtf_rs_teams_b T,
420: jtf_rs_team_usages TU, jtf_rs_role_relations TRR,
421: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
422: (
423: SELECT m.group_id group_id, m.resource_id resource_id
424: FROM jtf_rs_group_members m,
425: jtf_rs_groups_b g,

Line 429: jtf_rs_resource_extns res

425: jtf_rs_groups_b g,
426: jtf_rs_group_usages u,
427: jtf_rs_role_relations rr,
428: jtf_rs_roles_b r,
429: jtf_rs_resource_extns res
430: WHERE m.group_id = g.group_id
431: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
432: AND NVL(g.end_date_active,SYSDATE)
433: AND u.group_id = g.group_id

Line 477: jtf_rs_roles_b r, jtf_rs_resource_extns res,

473: MIN(jtm.team_id) team_id, res.CATEGORY resource_category,
474: MIN(res.source_id) person_id
475: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
476: jtf_rs_group_usages u, jtf_rs_role_relations rr,
477: jtf_rs_roles_b r, jtf_rs_resource_extns res,
478: (
479: SELECT tm.team_resource_id group_id,
480: t.team_id team_id
481: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,

Line 483: jtf_rs_roles_b tr, jtf_rs_resource_extns tres

479: SELECT tm.team_resource_id group_id,
480: t.team_id team_id
481: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,
482: jtf_rs_team_usages tu,jtf_rs_role_relations trr,
483: jtf_rs_roles_b tr, jtf_rs_resource_extns tres
484: WHERE tm.team_id = t.team_id
485: AND SYSDATE BETWEEN NVL(t.start_date_active,SYSDATE)
486: AND NVL(t.end_date_active,SYSDATE)
487: AND tu.team_id = t.team_id

Line 684: jtf_rs_roles_b r, jtf_rs_resource_extns res

680: res.category resource_category,
681: m.group_id group_id, MIN(res.source_id) person_id
682: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
683: jtf_rs_group_usages u, jtf_rs_role_relations rr,
684: jtf_rs_roles_b r, jtf_rs_resource_extns res
685: WHERE m.group_id = g.group_id
686: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
687: AND NVL(g.end_date_active,SYSDATE)
688: AND u.group_id = g.group_id

Line 2042: FROM jtf_rs_resource_extns res

2038: -- may not have person_id for all resources. Therefore, get person_id
2039: -- in this cursor, instead of in the above cursor.
2040: CURSOR c_get_person_id(c_resource_id NUMBER) IS
2041: SELECT res.source_id
2042: FROM jtf_rs_resource_extns res
2043: WHERE res.resource_id = c_resource_id;
2044:
2045: TYPE num_list IS TABLE of NUMBER INDEX BY BINARY_INTEGER;
2046: