[Home] [Help]
2181: AND ( ppt.system_person_type IN ('EMP', 'CWK')
2182: OR ( ppt.system_person_type = 'EX_EMP'
2183: AND EXISTS (
2184: SELECT NULL
2185: FROM per_periods_of_service pps
2186: WHERE papf.person_id = pps.person_id
2187: AND pps.date_start <= v_period_end_date --period end date
2188: AND pps.final_process_date >=
2189: v_period_start_date
2272: AND ( ppt.system_person_type IN ('EMP', 'CWK')
2273: OR ( ppt.system_person_type = 'EX_EMP'
2274: AND EXISTS (
2275: SELECT NULL
2276: FROM per_periods_of_service pps
2277: WHERE papf.person_id = pps.person_id
2278: AND pps.date_start <= v_period_end_dt --period end date
2279: AND pps.final_process_date >=
2280: v_period_st_dt