9: or new.evidence_status = 'CURRENT')
10: ) DECLARE
11: BEGIN
12: if hr_general.g_data_migrator_mode <> 'Y' then
13: if ssp_ssp_pkg.ssp_is_installed then
14: ssp_smp_pkg.medical_control (nvl (:old.maternity_id,:new.maternity_id));
15: ssp_ssp_pkg.medical_control (nvl (:old.absence_attendance_id,
16: :new.absence_attendance_id));
17: end if;
11: BEGIN
12: if hr_general.g_data_migrator_mode <> 'Y' then
13: if ssp_ssp_pkg.ssp_is_installed then
14: ssp_smp_pkg.medical_control (nvl (:old.maternity_id,:new.maternity_id));
15: ssp_ssp_pkg.medical_control (nvl (:old.absence_attendance_id,
16: :new.absence_attendance_id));
17: end if;
18: end if;
19: END;