Operation Details
Description: To retrieve a case deduction item record by financial component id.
Sterotype: ns
SQL 
SELECT
  CaseDeductionItem.caseDeductionItemID,
  CaseDeductionItem.concernRoleID,
  CaseDeductionItem.createdDate,
  CaseDeductionItem.startDate,
  CaseDeductionItem.endDate,
  CaseDeductionItem.rate,
  CaseDeductionItem.statusCode,
  CaseDeductionItem.comments,
  CaseDeductionItem.relatedCaseID,
  CaseDeductionItem.caseID,
  CaseDeductionItem.amount,
  CaseDeductionItem.deductionType,
  CaseDeductionItem.deductionID,
  CaseDeductionItem.rulesObjectiveID,
  CaseDeductionItem.priority,
  CaseDeductionItem.category,
  CaseDeductionItem.actionType,
  CaseDeductionItem.thirdPartyConcernRoleID,
  CaseDeductionItem.deductionName,
  CaseDeductionItem.customerAccName,
  CaseDeductionItem.customerAccNumber,
  CaseDeductionItem.caseNomineeID,
  CaseDeductionItem.versionNo
INTO
  :caseDeductionItemID,
  :concernRoleID,
  :createdDate,
  :startDate,
  :endDate,
  :rate,
  :statusCode,
  :comments,
  :relatedCaseID,
  :caseID,
  :amount,
  :deductionType,
  :deductionID,
  :rulesObjectiveID,
  :priority,
  :category,
  :actionType,
  :thirdPartyConcernRoleID,
  :deductionName,
  :customerAccName,
  :customerAccNumber,
  :caseNomineeID,
  :versionNo 
FROM
  CaseDeductionItem,
  CaseDeductionItemFCLink 
WHERE CaseDeductionItemFCLink.financialComponentID = :financialCompID 
  AND CaseDeductionItem.caseDeductionItemID = CaseDeductionItemFCLink.caseDeductionItemID