DBA Data[Home] [Help]

APPS.AS_GAR_ACCOUNTS_PUB dependencies on JTF_RS_TEAM_USAGES

Line 423: jtf_rs_team_usages TU, jtf_rs_role_relations TRR,

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

Line 485: jtf_rs_team_usages tu,jtf_rs_role_relations trr,

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