#encodeForHTML( _r.sql )#

#lsnumberformat( _r.recordCount )# rows delete from tbl_TPM_ClaimContracts where claimId = and ownerId = @ownerId and ownertype = @ownerType

#encodeForHTML( _r.sql )#

#lsnumberformat( _r.recordCount )# rows update tbl_TPM_Claims set claimStatus = 'OPEN', claimStatusComment = , claimStatusDate = , updateDate = , updateUserId = coalesce( claimStatusUserId, updateUserId ), verifiedAmount = 0, adjustmentAmount = 0, statusReasonId = null, processorUserId = null, adminFee = null, readyToAudit = 'N' where claimId = and ownerId = @ownerId and ownertype = @ownerType

#encodeForHTML( _r.sql )#

#lsnumberformat( _r.recordCount )# rows