Operation Details
Description: This method is used to get the deduction items associated with a component. This is used during the generation of FC's.
Sterotype: nsmulti
SQL 
SELECT
  caseDeductionItemID,
  concernRoleID,
  createdDate,
  startDate,
  endDate,
  statusCode,
  comments,
  relatedCaseID,
  caseID,
  rate,
  amount,
  deductionType,
  relatedObjectiveID,
  rulesObjectiveID,
  versionNo
INTO
  :caseDeductionItemID,
  :concernRoleID,
  :createdDate,
  :startDate,
  :endDate,
  :statusCode,
  :comments,
  :relatedCaseID,
  :caseID,
  :rate,
  :amount,
  :deductionType,
  :relatedObjectiveID,
  :rulesObjectiveID,
  :versionNo 
FROM
  CaseDeductionItem 
WHERE rulesObjectiveID = :rulesObjectiveID 
  AND caseID = :caseID 
  AND statusCode = :statusCode 
  AND startDate <= :effectiveDate