DBA Data[Home] [Help]

APPS.PV_TERR_ASSIGN_PUB dependencies on JTF_RS_TEAM_MEMBERS

Line 383: FROM jtf_rs_team_members tm,

379: min(tm.person_id) person_id,
380: min(g.group_id) group_id,
381: min(t.team_id) team_id,
382: tres.category resource_category
383: FROM jtf_rs_team_members tm,
384: jtf_rs_teams_b t,
385: jtf_rs_team_usages tu,
386: jtf_rs_role_relations trr,
387: jtf_rs_roles_b tr,

Line 450: FROM jtf_rs_team_members tm,

446: jtf_rs_roles_b r,
447: jtf_rs_resource_extns res,
448: (
449: SELECT tm.team_resource_id group_id, t.team_id team_id
450: FROM jtf_rs_team_members tm,
451: jtf_rs_teams_b t,
452: jtf_rs_team_usages tu,
453: jtf_rs_role_relations trr,
454: jtf_rs_roles_b tr,