DBA Data[Home] [Help]

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'