TRIGGER: APPS.JTF_DAC_CRITERIA_TR2

Source

Description

JTF_DAC_CRITERIA_TR2
AFTER DELETE ON JTF.JTF_DAC_CRITERIA
FOR EACH ROW

Type

AFTER EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
DELETE FROM JTF_DAC_ROLE_PERM_CRIT
  WHERE JTF_DAC_ROLE_PERM_CRIT.CRITERIA_ID = :old.CRITERIA_ID ;
END ;