Operation Details
Description: Searches for case deduction items based on deduction name, business status and record status, and within a certain date range.
Sterotype: nsmulti
SQL 
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 deductionName = :deductionName 
  AND statusCode = :statusCode 
  AND businessStatus = :businessStatus 
  AND startDate <= :endDate 
  AND endDate >= :startDate