TRIGGER: APPS.XTR_AD_INTERACCT_TRANSFERS_T

Source

Description

XTR_AD_INTERACCT_TRANSFERS_T
	 AFTER DELETE on 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;