TRIGGER: APPS.JTF_DAC_ROLE_PERMS_TR2

Source

Description

"APPS"."JTF_DAC_ROLE_PERMS_TR2" 
AFTER DELETE
 ON  "JTF"."JTF_DAC_ROLE_PERMS#"  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_CRITERIA
  WHERE ROLE_PERM_ID = :old.ROLE_PERM_ID ;
DELETE FROM JTF_DAC_ROLE_PERM_CRIT
  WHERE ROLE_PERM_ID = :old.ROLE_PERM_ID ;

END ;