delete from tbl_TPM_Accruals where ownerId = and ownerType = and entryType in ( 'CLAIM', 'CLAIM_REVERSAL' ) select ct.partnerId, ct.partnerType, c.claimDate, c.claimId, c.claimPeriodStart, c.claimPeriodEnd, ct.assignedContractNbr, ct.contractName, cc.approvedAmount, cc.firstDate, cc.lastDate, r.requestId, coalesce( cc.lastDate, coalesce( c.claimPeriodEnd, c.claimDate )) as entryDate from tbl_TPM_ClaimContracts cc inner join tbl_TPM_Requests r on r.requestId = cc.requestId and r.ownerId = cc.ownerId and r.ownerType = cc.ownerType inner join tbl_TPM_RequestTypes rt on rt.requestTypeId = r.requesttypeId and rt.ownerId = r.ownerId and rt.ownerType = r.ownerType and rt.requestModel = 'INCENTIVE' inner join tbl_TPM_Claims c on c.claimId = cc.claimId and c.ownerId = cc.ownerId and c.ownerType = cc.ownerType inner join tbl_TPM_Contracts ct on ct.contractId = r.contractId and ct.ownerId = r.ownerId and ct.ownerType = r.ownertype and ct.partnerType = 'CDR' where cc.reconciled = 'Y' and cc.ownerId = and cc.ownerType = order by c.claimDate select accrualId, description, fiscalYear, fiscalMonth from tbl_TPM_Accruals with (nolock) where ownerId = and ownerType = and cdr_recordId = and sourceId = and sourceType = 'TPC' and entryDate = and entryType =
Patching #qmd_check.accrualId# (#qmd_check.description# #qmd_check.fiscalMonth# #qmd_check.fiscalYear#)...
update tbl_TPM_Accruals set description = , fiscalYear = , fiscalMonth = , updateDate = where ownerId = and ownerType = and accrualId = and sourceId = and sourceType = 'TPC' and entryDate = and entryType = and ( description <> or fiscalYear <> or fiscalMonth <> )
Patched #qmd_check.accrualId# (#_withdrawlDescription# #_fiscalMonth# #_fiscalYear#)!!!
Adding #_withdrawlDescription# #lscurrencyformat( _withdrawlAmount )#
insert into tbl_TPM_Accruals ( ownerId, ownerType, cdr_recordId, entryDate, description, amount, sourceId, sourceType, createDate, linkId2, linkType2, fiscalYear, fiscalMonth, entryType ) values( , , , , , , , , , , , , , )