APPS.PQH_PSU_BUS dependencies on PER_ALL_PEOPLE_F

Line 418: FROM per_all_people_f

414: -- ----------------------------------------------------------------------------
415: Procedure chk_person_id(p_person_id IN NUMBER) IS
416: CURSOR csr_valid_emp(p_person_id IN NUMBER) IS
417: SELECT 'X'
418: FROM per_all_people_f
419: WHERE person_id = p_person_id
420: AND TRUNC(SYSDATE) between effective_start_date and effective_end_date
421: AND PER_INFORMATION15 = '01'
422: AND current_employee_flag = 'Y';

Line 730: from per_all_people_f

726: IS
727: --
728: Cursor csr_person_info IS
729: Select original_date_of_hire
730: from per_all_people_f
731: where person_id = p_person_id
732: and trunc(sysdate) between effective_start_date and effective_end_date;
733: --
734: Cursor csr_situation_info IS