2192: )
2193: OR ( ppt.system_person_type = 'EX_CWK'
2194: AND EXISTS (
2195: SELECT NULL
2196: FROM per_periods_of_placement pps
2197: WHERE papf.person_id = pps.person_id
2198: AND pps.date_start <= v_period_end_date --period end date
2199: AND pps.final_process_date >=
2200: v_period_start_date
2283: )
2284: OR ( ppt.system_person_type = 'EX_CWK'
2285: AND EXISTS (
2286: SELECT NULL
2287: FROM per_periods_of_placement pps
2288: WHERE papf.person_id = pps.person_id
2289: AND pps.date_start <= v_period_end_dt --period end date
2290: AND pps.final_process_date >=
2291: v_period_st_dt