[Home] [Help]
TRIGGER: APPS.CZ_EFFECTIVITY_SETS_T1
Source
Description
CZ_EFFECTIVITY_SETS_T1
BEFORE DELETE
ON CZ_EFFECTIVITY_SETS
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
Type
BEFORE EACH ROW
Event
DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
BEGIN
DELETE FROM CZ_RP_ENTRIES
WHERE OBJECT_TYPE = 'EFF' AND OBJECT_ID = :OLD.EFFECTIVITY_SET_ID;
END;