APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on JTF_RS_TEAMS_B

Line 1019: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,

1015: SELECT MIN(tm.team_resource_id) resource_id,
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

Line 1075: From jtf_rs_team_members tm, jtf_rs_teams_b t,

1071: jtf_rs_group_usages u, jtf_rs_role_relations rr,
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)

Line 2143: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,

2139: SELECT MIN(tm.team_resource_id) resource_id,
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

Line 2199: From jtf_rs_team_members tm, jtf_rs_teams_b t,

2195: jtf_rs_group_usages u, jtf_rs_role_relations rr,
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)