APPS.PA_PROJECT_PARTIES_UTILS dependencies on PER_ALL_PEOPLE_F

Line 710: per_all_people_f pe

706: x_project_role_name,
707: x_manager_name
708: FROM pa_project_parties ppp,
709: pa_project_role_types pprt,
710: per_all_people_f pe
711: WHERE ppp.project_id = p_project_id
712: AND ppp.project_role_id = 1
713: AND ppp.project_role_id = pprt.project_role_id
714: AND ppp.resource_type_id = 101

Line 734: per_all_people_f pe

730: x_project_role_name,
731: x_manager_name
732: FROM pa_project_parties ppp,
733: pa_project_role_types pprt,
734: per_all_people_f pe
735: WHERE ppp.project_id = p_project_id
736: AND ppp.project_role_id = 1
737: AND ppp.project_role_id = pprt.project_role_id
738: AND ppp.resource_type_id = 101

Line 895: FROM per_all_people_f

891:
892: CURSOR C1(c_person_id NUMBER)
893: IS
894: Select full_name
895: FROM per_all_people_f
896: WHERE PERSON_ID = c_person_id
897: AND trunc(SYSDATE) between trunc(effective_start_date) and trunc(effective_end_date); -- Bug 3283351
898:
899: l_return_value VARCHAR2(250);

Line 921: per_all_people_f PPF

917: Select ppf.full_name
918: FROM PA_PROJECT_PARTIES PPP,
919: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
920: PA_PROJECT_ROLE_TYPES_B PPRT,
921: per_all_people_f PPF
922: WHERE
923: PPP.PROJECT_ID = p_project_id
924: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
925: AND ppp.resource_type_id = 101 --Added this condition to improve performance. Bug:4752054

Line 1344: per_all_people_f PPF

1340: Select ppf.full_name
1341: FROM PA_PROJECT_PARTIES PPP,
1342: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
1343: PA_PROJECT_ROLE_TYPES_B PPRT,
1344: per_all_people_f PPF
1345: WHERE
1346: PPP.PROJECT_ID = p_project_id
1347: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1348: AND ppp.resource_type_id = 101 --Added this condition to improve performance. Bug:4752054