CREATE OR REPLACE TRIGGER EXC_DUPLICATA_REC
AFTER DELETE ON CONTARECEBER FOR EACH ROW
BEGIN
   UPDATE USR_CARGA_DUPLICATA
   SET TP_ATUALIZACAO = 'E'
   WHERE TX_FILIAL  = :OLD.CDFILIAL    AND
         TX_LANCNF  = :OLD.NRLANCTONF  AND
         TX_SEQLANC = :OLD.NRSEQVENREC AND
         TX_PARCELA = :OLD.NRPARCELAREC;
END;
/

-- VERSAO --
BEGIN ATUVEROBJ('EXC_DUPLICATA_REC','4.11.033'); END;
/

