TR_REVENUESPLIT_DELETE_BBNCREVENUESPLITIDMAP

        CREATE trigger TR_REVENUESPLIT_DELETE_BBNCREVENUESPLITIDMAP on dbo.REVENUESPLIT after delete not for replication
        as begin
          delete from dbo.BBNCREVENUESPLITIDMAP
            where REVENUESPLITID in (select ID from deleted)
        end