262: --
263: DELETE from per_nl_absence_changes pnac
264: WHERE months_between(trunc(v_effective_date), pnac.date_changed) > 12
265: AND person_id in ( SELECT person_id
266: FROM per_all_people_f
267: WHERE business_group_id = p_business_group_id);
268: --
269: end purge_per_nl_absence_changes;
270: --