APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on JTF_RS_TEAM_USAGES

Line 1019: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

1015: MIN(tm.person_id) person_id2, MIN(G.group_id) group_id,
1016: MIN(t.team_id) team_id, tres.category resource_category,
1017: MIN(TRES.source_id) person_id
1018: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,
1019: jtf_rs_team_usages tu, jtf_rs_role_relations trr,
1020: jtf_rs_roles_b tr, jtf_rs_resource_extns tres,
1021: (
1022: SELECT m.group_id group_id, m.resource_id resource_id
1023: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

Line 1075: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

1071: jtf_rs_roles_b r, jtf_rs_resource_extns res,
1072: (
1073: Select tm.team_resource_id group_id, t.team_id team_id
1074: From jtf_rs_team_members tm, jtf_rs_teams_b t,
1075: jtf_rs_team_usages tu, jtf_rs_role_relations trr,
1076: jtf_rs_roles_b tr, jtf_rs_resource_extns tres
1077: Where tm.team_id = t.team_id
1078: and sysdate between nvl(t.start_date_active,sysdate)
1079: and nvl(t.end_date_active,sysdate)

Line 2143: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

2139: MIN(tm.person_id) person_id2, MIN(G.group_id) group_id,
2140: MIN(t.team_id) team_id, tres.category resource_category,
2141: MIN(TRES.source_id) person_id
2142: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,
2143: jtf_rs_team_usages tu, jtf_rs_role_relations trr,
2144: jtf_rs_roles_b tr, jtf_rs_resource_extns tres,
2145: (
2146: SELECT m.group_id group_id, m.resource_id resource_id
2147: FROM jtf_rs_group_members m, jtf_rs_groups_b g,

Line 2199: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

2195: jtf_rs_roles_b r, jtf_rs_resource_extns res,
2196: (
2197: Select tm.team_resource_id group_id, t.team_id team_id
2198: From jtf_rs_team_members tm, jtf_rs_teams_b t,
2199: jtf_rs_team_usages tu, jtf_rs_role_relations trr,
2200: jtf_rs_roles_b tr, jtf_rs_resource_extns tres
2201: Where tm.team_id = t.team_id
2202: and sysdate between nvl(t.start_date_active,sysdate)
2203: and nvl(t.end_date_active,sysdate)