TR_BANKACCOUNTDEPOSIT_DELETE_POSTED (Trigger)

                
CREATE trigger dbo.TR_BANKACCOUNTDEPOSIT_DELETE_POSTED ON dbo.BANKACCOUNTDEPOSIT FOR DELETE NOT FOR REPLICATION AS
BEGIN
    SET NOCOUNT ON;
    
    if exists(select DELETED.ID    from DELETED
            inner join dbo.BANKACCOUNTTRANSACTION on DELETED.ID = BANKACCOUNTTRANSACTION.ID
            where BANKACCOUNTTRANSACTION.POSTSTATUSCODE = 0)
    begin
        RAISERROR ('ERR_DELETE_POSTED_TRANSACTION.',  16, 1)
        ROLLBACK TRANSACTION
    end
  
  delete dbo.DEPOSITGLDISTRIBUTIONLINK  
    from dbo.DEPOSITGLDISTRIBUTIONLINK as DGL 
    inner join deleted as BAD on DGL.DEPOSITID = BAD.ID
  
end