Operation Details
Description: Returns a list of instruction line items based on a specified case and cover period. This is subtly different from the searchByCaseIDCoverPeriodOverlap() operation insofar as it searches for records within the specified period.
Sterotype: nsmulti
SQL 
SELECT
  InstructionLineItem.instructLineItemID,
  InstructionLineItem.amount,
  InstructionLineItem.instructLineItemCategory,
  InstructionLineItem.instructionLineItemType,
  InstructionLineItem.financialCompID,
  InstructionLineItem.coverPeriodFrom,
  InstructionLineItem.coverPeriodTo,
  InstructionLineItem.statusCode,
  InstructionLineItem.deliveryMethodType,
  CaseNominee.caseNomineeID
INTO
  :instructLineItemID,
  :amount,
  :instructLineItemCategory,
  :instructionLineItemType,
  :financialCompID,
  :coverPeriodFrom,
  :coverPeriodTo,
  :statusCode,
  :deliveryMethodType,
  :caseNomineeID 
FROM
  InstructionLineItem,
  CaseNominee 
WHERE InstructionLineItem.caseID = :caseID 
  AND InstructionLineItem.caseNomineeID = CaseNominee.caseNomineeID 
  AND InstructionLineItem.coverPeriodFrom >= :coverPeriodFrom 
  AND InstructionLineItem.coverPeriodTo <= :coverPeriodTo 
ORDER BY InstructionLineItem.coverPeriodFrom,
  InstructionLineItem.coverPeriodTo,
  CaseNominee.caseNomineeID