APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PER_ALL_PEOPLE_F

Line 582: FROM per_all_people_f

578: BEGIN
579: SELECT 'Y'
580: INTO l_cwk_flag
581: --FROM per_people_x
582: FROM per_all_people_f
583: WHERE person_id = p_person_id
584: AND current_npw_flag = 'Y'
585: AND trunc(sysdate) between trunc(effective_start_date) AND
586: trunc(effective_end_date);

Line 686: --FROM per_all_people_f

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

Line 787: FROM per_all_people_f per

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

Line 2224: FROM per_all_people_f peo

2220:
2221: UPDATE pa_res_members_temp res_temp
2222: SET person_type_code = (SELECT
2223: decode(peo.current_employee_flag, 'Y', 'EMP', 'CWK')
2224: FROM per_all_people_f peo
2225: WHERE peo.person_id = res_temp.person_id
2226: AND SYSDATE BETWEEN peo.effective_start_date
2227: AND peo.effective_end_date
2228: AND ROWNUM = 1)