APPS.HR_KW_VALIDATE_PKG dependencies on PER_ALL_PEOPLE_F

Line 151: FROM per_all_people_f

147: ,p_per_information10 in varchar2 default null
148: ) IS
149: CURSOR csr_person_type_id IS
150: SELECT person_type_id
151: FROM per_all_people_f
152: WHERE person_id = p_person_id
153: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
154: l_person_type_id NUMBER;
155: l_person_type VARCHAR2(20);

Line 916: FROM per_all_people_f

912: v_field VARCHAR2(300) := NULL;
913:
914: CURSOR csr_nationality IS
915: SELECT NATIONALITY
916: FROM per_all_people_f
917: WHERE person_id = l_person_id
918: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
919: BEGIN
920: