6: if hr_general.g_data_migrator_mode <> 'Y' then
7: --
8: if :old.maternity_id is null then
9: --
10: hr_utility.set_location('ssp_del_orphaned_rows',1);
11: delete from ssp_stoppages
12: where absence_attendance_id = :old.absence_attendance_id;
13: --
14: hr_utility.set_location('ssp_del_orphaned_rows',2);
10: hr_utility.set_location('ssp_del_orphaned_rows',1);
11: delete from ssp_stoppages
12: where absence_attendance_id = :old.absence_attendance_id;
13: --
14: hr_utility.set_location('ssp_del_orphaned_rows',2);
15: delete from ssp_medicals
16: where absence_attendance_id = :old.absence_attendance_id;
17: --
18: hr_utility.set_location('ssp_del_orphaned_rows',3);
14: hr_utility.set_location('ssp_del_orphaned_rows',2);
15: delete from ssp_medicals
16: where absence_attendance_id = :old.absence_attendance_id;
17: --
18: hr_utility.set_location('ssp_del_orphaned_rows',3);
19: end if;
20: end if;
21: end ssp_del_orphaned_rows;
22: