APPS.HR_RU_PEOPLE_LEG_HOOK dependencies on PER_PERSON_TYPE_USAGES_F

Line 808: FROM per_person_types ppt, per_person_type_usages_f ptu

804:
805: CURSOR csr_ptu_type (c_person_id NUMBER, c_session_date DATE)
806: IS
807: SELECT ppt.system_person_type, ppt.seeded_person_type_key
808: FROM per_person_types ppt, per_person_type_usages_f ptu
809: WHERE ppt.person_type_id = ptu.person_type_id
810: AND c_session_date BETWEEN ptu.effective_start_date
811: AND ptu.effective_end_date
812: AND ptu.person_id = c_person_id;

Line 830: ELSE --else get from per_person_type_usages_f

826: FETCH csr_val_person_type
827: INTO l_system_person_type, l_seeded_person_type_key;
828:
829: CLOSE csr_val_person_type;
830: ELSE --else get from per_person_type_usages_f
831: OPEN csr_ptu_type (p_person_id, l_effective_date);
832:
833: FETCH csr_ptu_type
834: INTO l_system_person_type, l_seeded_person_type_key;