APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on JTF_RS_TEAM_USAGES

Line 1020: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

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

Line 1076: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

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

Line 2144: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

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

Line 2200: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

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