APPS.HR_KW_VALIDATE_PKG dependencies on PER_ALL_PEOPLE_F

Line 139: FROM per_all_people_f

135: ,p_per_information10 in varchar2 default null
136: ) IS
137: CURSOR csr_person_type_id IS
138: SELECT person_type_id
139: FROM per_all_people_f
140: WHERE person_id = p_person_id
141: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
142: l_person_type_id NUMBER;
143: l_person_type VARCHAR2(20);

Line 904: FROM per_all_people_f

900: v_field VARCHAR2(300) := NULL;
901:
902: CURSOR csr_nationality IS
903: SELECT NATIONALITY
904: FROM per_all_people_f
905: WHERE person_id = l_person_id
906: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
907: BEGIN
908: