TR_CONSTITUENTCORRESPONDENCERESPONSE_T2BDELETE

    CREATE trigger TR_CONSTITUENTCORRESPONDENCERESPONSE_T2BDELETE on dbo.CONSTITUENTCORRESPONDENCERESPONSE after delete not for replication
    as begin
      if dbo.UFN_B2T_CONTEXTISSYNC() = 0
          -- force re-sync of the parent row

        update dbo.TA_CONSTITUENTCORRESPONDENCE
        set ACTIONCODE = case when ACTIONCODE=1 then 1 else 2 end
        where ID in(select CONSTITUENTCORRESPONDENCEID from DELETED)
    end