DBA Data[Home] [Help]

APPS.HR_AE_VALIDATE_PKG dependencies on PER_ALL_PEOPLE_F

Line 298: FROM per_all_people_f

294: ,p_per_information20 in varchar2 default null
295: ) IS
296: CURSOR csr_person_type_id IS
297: SELECT person_type_id
298: FROM per_all_people_f
299: WHERE person_id = p_person_id
300: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
301: l_person_type_id NUMBER;
302: l_person_type VARCHAR2(20);