TRIGGER: APPS.XTR_AD_INTERACCT_TRANSFERS_T

Source

Description

"APPS"."XTR_AD_INTERACCT_TRANSFERS_T" 
	 AFTER DELETE
 ON  "XTR"."XTR_INTERACCT_TRANSFERS#"  	 FOR EACH ROW

Type

AFTER EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
   --Delete row from XTR_CONFIRMATION_DETAILS table

      DELETE from XTR_CONFIRMATION_DETAILS
      WHERE deal_type = 'IAC'
       and transaction_no = :OLD.TRANSACTION_NUMBER;

end;