1386: GROUP BY person_id
1387: HAVING MAX(actual_termination_date) < SYSDATE
1388: UNION
1389: SELECT person_id
1390: FROM per_periods_of_placement ppop
1391: WHERE ppop.person_id = per.person_id
1392: AND ppop.actual_termination_date is not null
1393: AND NOT EXISTS (SELECT 1
1394: FROM per_periods_of_placement
1390: FROM per_periods_of_placement ppop
1391: WHERE ppop.person_id = per.person_id
1392: AND ppop.actual_termination_date is not null
1393: AND NOT EXISTS (SELECT 1
1394: FROM per_periods_of_placement
1395: WHERE person_id = ppop.person_id
1396: AND actual_termination_date IS NULL )
1397: GROUP BY person_id
1398: HAVING MAX(actual_termination_date) < SYSDATE )