TRIGGER: APPS.SSP_ERN_T2

Source

Description

ssp_ern_t2
AFTER INSERT OR DELETE OR UPDATE
OF AVERAGE_EARNINGS_AMOUNT
ON SSP_EARNINGS_CALCULATIONS

Type

AFTER STATEMENT

Event

INSERT OR UPDATE OR DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
BEGIN
if hr_general.g_data_migrator_mode <> 'Y' then
  ssp_smp_support_pkg.recalculate_ssp_and_smp;
end if;
END;