DBA Data[Home] [Help]

APPS.PRP_RTTAP_INT_PVT dependencies on JTF_RS_TEAM_MEMBERS

Line 316: FROM jtf_rs_team_members TM, jtf_rs_teams_b T,

312: MIN(G.group_id)group_id,
313: MIN(T.team_id) team_id,
314: TRES.CATEGORY resource_category,
315: MIN(TRES.source_id) person_id
316: FROM jtf_rs_team_members TM, jtf_rs_teams_b T,
317: jtf_rs_team_usages TU, jtf_rs_role_relations TRR,
318: jtf_rs_roles_b TR, jtf_rs_resource_extns TRES,
319: (
320: SELECT m.group_id group_id, m.resource_id resource_id

Line 378: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,

374: jtf_rs_roles_b r, jtf_rs_resource_extns res,
375: (
376: SELECT tm.team_resource_id group_id,
377: t.team_id team_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: WHERE tm.team_id = t.team_id
382: AND SYSDATE BETWEEN NVL(t.start_date_active,SYSDATE)