Operation Details
Description: To retrieve a subset of InstructionLineItems details for a specified CaseID, Status & Date Range
Sterotype: nsmulti
SQL 
SELECT
  instructLineItemID,
  amount,
  unprocessedAmount,
  instructLineItemCategory,
  instructionLineItemType,
  effectiveDate,
  finInstructionID,
  concernRoleID,
  creditDebitType,
  statusCode,
  caseNomineeID,
  deliveryMethodType
INTO
  :instructLineItemID,
  :amount,
  :unprocessedAmount,
  :instructLineItemCategory,
  :instructionLineItemType,
  :effectiveDate,
  :finInstructionID,
  :concernRoleID,
  :creditDebitType,
  :statusCode,
  :caseNomineeID,
  :deliveryMethod 
FROM
  InstructionLineItem 
WHERE InstructionLineItem.caseID = :caseID 
  AND InstructionLineItem.statusCode = :statusCode 
  AND InstructionLineItem.effectiveDate >= :effectiveDateFrom 
  AND InstructionLineItem.effectiveDate <= :effectiveDateTo 
ORDER BY effectiveDate DESC