Operation Details
Description: Retrieves records from the CaseDeductionItem entity based on caseID. Gets the caseReference form the CaseHeader.
Sterotype: nsmulti
SQL 
SELECT
  CaseDeductionItem.caseDeductionItemID,
  CaseDeductionItem.concernRoleID,
  CaseDeductionItem.createdDate,
  CaseDeductionItem.startDate,
  CaseDeductionItem.endDate,
  CaseDeductionItem.statusCode,
  CaseDeductionItem.comments,
  CaseDeductionItem.relatedCaseID,
  CaseDeductionItem.caseID,
  CaseDeductionItem.rate,
  CaseDeductionItem.amount,
  CaseDeductionItem.deductionType,
  CaseDeductionItem.relatedObjectiveID,
  CaseDeductionItem.rulesObjectiveID,
  CaseDeductionItem.versionNo,
  CaseHeader.caseReference
INTO
  :caseDeductionItemID,
  :concernRoleID,
  :createdDate,
  :startDate,
  :endDate,
  :statusCode,
  :comments,
  :relatedCaseID,
  :caseID,
  :rate,
  :amount,
  :deductionType,
  :relatedObjectiveID,
  :rulesObjectiveID,
  :versionNo,
  :caseReference 
FROM
  CaseDeductionItem,
  CaseHeader 
WHERE CaseDeductionItem.caseID = CaseHeader.caseID 
  AND CaseDeductionItem.caseID = :caseID