APPS.PA_ASSIGNMENT_UTILS dependencies on PA_PROJECT_PARTIES

Line 1093: FROM pa_project_parties pp

1089: l_exp_org_id pa_project_assignments.expenditure_org_id%TYPE := null;
1090:
1091: CURSOR get_team_member(c_project_role_id NUMBER) IS
1092: SELECT pp.resource_source_id, res.full_name
1093: FROM pa_project_parties pp
1094: ,per_all_people_f res
1095: WHERE pp.project_role_id = c_project_role_id
1096: AND pp.resource_type_id = 101 -- Bug 4752052 - added to improve performance
1097: AND TRUNC(sysdate) between TRUNC(pp.start_date_active) and TRUNC(nvl(pp.end_date_active, sysdate))

Line 1169: FROM pa_project_parties ,

1165: l_person_id_tbl system.pa_num_tbl_type;
1166:
1167: CURSOR get_all_staffing_owners IS
1168: SELECT resource_source_id
1169: FROM pa_project_parties ,
1170: per_all_people_f ppf
1171: WHERE project_role_id = 8
1172: AND resource_type_id = 101 -- Bug 4752052 - added to improve performance
1173: AND TRUNC ( sysdate ) BETWEEN TRUNC ( start_date_active ) AND TRUNC ( NVL ( end_date_active, sysdate ) )