APPS.PA_PROJECT_PARTIES_UTILS dependencies on PER_ALL_PEOPLE_F

Line 707: per_all_people_f pe

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

Line 731: per_all_people_f pe

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

Line 892: FROM per_all_people_f

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

Line 918: per_all_people_f PPF

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

Line 1330: per_all_people_f PPF

1326: Select ppf.full_name
1327: FROM PA_PROJECT_PARTIES PPP,
1328: --PA_PROJECT_ROLE_TYPES PPRT, --bug 4004821
1329: PA_PROJECT_ROLE_TYPES_B PPRT,
1330: per_all_people_f PPF
1331: WHERE
1332: PPP.PROJECT_ID = p_project_id
1333: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1334: AND ppp.resource_type_id = 101 --Added this condition to improve performance. Bug:4752054