TRIGGER: APPS.SSP_MAT_T2

Source

Description

ssp_mat_t2
AFTER INSERT OR DELETE OR UPDATE
OF ACTUAL_BIRTH_DATE
,  DUE_DATE
,  LIVE_BIRTH_FLAG
,  MPP_START_DATE
,  NOTIFICATION_OF_BIRTH_DATE
,  PAY_SMP_AS_LUMP_SUM
,  START_DATE_WITH_NEW_EMPLOYER
ON SSP_MATERNITIES

Type

AFTER STATEMENT

Event

INSERT OR UPDATE OR DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
BEGIN
  ssp_smp_support_pkg.recalculate_ssp_and_smp;
END;