Operation Details
Description: To retrieve any case deduction items using the case ID, record status, business status and effective date.
Sterotype: nsmulti
SQL 
SELECT
  caseDeductionItemID,
  concernRoleID,
  createdDate,
  startDate,
  endDate,
  statusCode,
  comments,
  relatedCaseID,
  caseID,
  rate,
  amount,
  deductionType,
  relatedObjectiveID,
  rulesObjectiveID,
  caseNomineeID,
  versionNo
INTO
  :caseDeductionItemID,
  :concernRoleID,
  :createdDate,
  :startDate,
  :endDate,
  :statusCode,
  :comments,
  :relatedCaseID,
  :caseID,
  :rate,
  :amount,
  :deductionType,
  :relatedObjectiveID,
  :rulesObjectiveID,
  :caseNomineeID,
  :versionNo 
FROM
  CaseDeductionItem 
WHERE caseID = :caseID 
  AND businessStatus = :businessStatus 
  AND statusCode = :status 
  AND startDate <= :effectiveDate