APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PER_ALL_PEOPLE_F

Line 578: FROM per_all_people_f

574: BEGIN
575: SELECT 'Y'
576: INTO l_cwk_flag
577: --FROM per_people_x
578: FROM per_all_people_f
579: WHERE person_id = p_person_id
580: AND current_npw_flag = 'Y'
581: AND trunc(sysdate) between trunc(effective_start_date) AND
582: trunc(effective_end_date);

Line 682: --FROM per_all_people_f

678: * consistent with the other selects.
679: ***************************************************/
680: Cursor c_ids IS
681: SELECT person_id
682: --FROM per_all_people_f
683: FROM per_people_x
684: WHERE full_name = p_person_name;
685: --AND trunc(sysdate) between trunc(effective_start_date) AND
686: --trunc(effective_end_date);

Line 783: FROM per_all_people_f per

779: *****************************************************/
780: BEGIN
781: SELECT person_id
782: INTO x_person_id
783: FROM per_all_people_f per
784: WHERE
785: --sysdate BETWEEN effective_start_date AND effective_end_date
786: (current_employee_flag = 'Y' or CURRENT_NPW_FLAG = 'Y')
787: AND ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y') OR

Line 2184: FROM per_all_people_f peo

2180:
2181: UPDATE pa_res_members_temp res_temp
2182: SET person_type_code = (SELECT
2183: decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK')
2184: FROM per_all_people_f peo
2185: WHERE peo.person_id = res_temp.person_id
2186: AND SYSDATE BETWEEN peo.effective_start_date
2187: AND peo.effective_end_date
2188: AND ROWNUM = 1)