Operation Details
Description: To get a list of instructionLineItem for a particular categoryCode, TypeCode, effectiveDate, and adjustmentInd.
Sterotype: nsmulti
SQL 
SELECT
  instructLineItemID,
  amount,
  unprocessedAmount,
  instructLineItemCategory,
  instructionLineItemType,
  financialCompID,
  coverPeriodFrom,
  coverPeriodTo,
  effectiveDate,
  creationDate,
  statusCode,
  caseID,
  finInstructionID,
  concernRoleID,
  caseNomineeID,
  primaryClientID,
  deliveryMethodType,
  creditDebitType,
  currencyExchangeID,
  currencyTypeCode,
  adjustmentInd,
  adjustmentFrequency,
  nextAdjustmentDate,
  instrumentGenInd,
  fundID,
  maximumAmount,
  versionNo,
  dueDate,
  inRespectOfID
INTO
  :instructLineItemID,
  :amount,
  :unprocessedAmount,
  :instructLineItemCategory,
  :instructionLineItemType,
  :financialCompID,
  :coverPeriodFrom,
  :coverPeriodTo,
  :effectiveDate,
  :creationDate,
  :statusCode,
  :caseID,
  :finInstructionID,
  :concernRoleID,
  :caseNomineeID,
  :primaryClientID,
  :deliveryMethodType,
  :creditDebitType,
  :currencyExchangeID,
  :currencyTypeCode,
  :adjustmentInd,
  :adjustmentFrequency,
  :nextAdjustmentDate,
  :instrumentGenInd,
  :fundID,
  :maximumAmount,
  :versionNo,
  :dueDate,
  :inRespectOfID 
FROM
  InstructionLineItem 
WHERE caseNomineeID = :caseNomineeID 
  AND instructLineItemCategory = :instructLineItemCategory 
  AND instructionLineItemType = :instructionLineItemType 
  AND adjustmentInd = :adjustmentInd 
  AND effectiveDate <= :effectiveDate