TRIGGER: APPS.JTF_DAC_CRITERIA_TR2

Source

Description

"APPS"."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 ;