SELECT
caseDeductionItemID,
concernRoleID,
createdDate,
startDate,
endDate,
statusCode,
comments,
relatedCaseID,
caseID,
rate,
amount,
relatedObjectiveID,
rulesObjectiveID,
deductionType,
deductionName,
thirdPartyConcernRoleID,
customerAccName,
customerAccNumber,
priority,
category,
businessStatus,
actionType
INTO
:caseDeductionItemID,
:concernRoleID,
:createdDate,
:startDate,
:endDate,
:statusCode,
:comments,
:relatedCaseID,
:caseID,
:rate,
:amount,
:relatedObjectiveID,
:rulesObjectiveID,
:deductionType,
:deductionName,
:thirdPartyConcernRoleID,
:customerAccName,
:customerAccNumber,
:priority,
:category,
:businessStatus,
:actionType
FROM
CaseDeductionItem
WHERE caseID = :caseID
AND deductionName = :deductionName
AND statusCode = :statusCode
AND businessStatus = :businessStatus
AND
(
startDate <= :endDate
OR :endDate IS NULL
)
AND
(
endDate >= :startDate
OR endDate IS NULL
)
|