APPS.PA_ASSIGNMENT_UTILS dependencies on PER_ALL_PEOPLE_F

Line 1094: ,per_all_people_f res

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))
1098: AND pp.project_id = p_project_id

Line 1170: per_all_people_f ppf

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 ) )
1174: AND project_id = p_project_id

Line 1183: per_all_people_f ppf

1179: AND ( ppf.current_employee_flag = 'Y' OR ppf.current_npw_flag = 'Y' )
1180: UNION ALL
1181: SELECT staffing_owner_person_id
1182: FROM pa_project_assignments,
1183: per_all_people_f ppf
1184: WHERE assignment_id = p_assignment_id
1185: AND ppf.person_id = staffing_owner_person_id -- Bug Ref # 6802697
1186: AND TRUNC ( sysdate ) BETWEEN effective_start_date AND effective_end_date
1187: AND ( ppf.current_employee_flag = 'Y' OR ppf.current_npw_flag = 'Y' ) ;

Line 1294: per_all_people_f peo

1290: per_person_types ppt,
1291: per_all_assignments_f aaf,
1292: pa_resource_txn_attributes rta,
1293: pa_resources_denorm rd,
1294: per_all_people_f peo
1295: where asgn.project_id = p_project_id
1296: and asgn.resource_id = rta.resource_id
1297: and rta.person_id = aaf.person_id
1298: and asgn.start_date between aaf.effective_start_date AND aaf.effective_end_date