TRIGGER: APPS.SSP_STP_T2

Source

Description

ssp_stp_t2
AFTER DELETE
ON SSP_STOPPAGES
FOR EACH ROW

Type

AFTER EACH ROW

Event

DELETE

Column

When

old.user_entered = 'Y'
    

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
BEGIN
if hr_general.g_data_migrator_mode <> 'Y' then
  if ssp_ssp_pkg.ssp_is_installed then
    ssp_ssp_pkg.stoppage_control (:old.absence_attendance_id);
    ssp_smp_pkg.stoppage_control (:old.maternity_id);
  end if;
end if;
END;