APPS.PAY_GB_RTI_UPD dependencies on PER_PERSON_TYPES
Line 12: ,per_person_types ppt
8: BEGIN
9: SELECT 1
10: INTO var
11: FROM per_all_people_f pap 12: ,per_person_types ppt 13: WHERE p_effective_date BETWEEN pap.effective_start_date
14: AND pap.effective_end_date
15: AND pap.person_id = p_person_id
16: AND ppt.system_person_type = 'EMP'