TR_BANKACCOUNTDEPOSIT_DELETE_POSTED

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