Operation Details
Description: Gets a list of instructionLineItem for a particular categoryCode and statusCode.
Sterotype: nsmulti
SQL 
SELECT
  InstructionLineItem.instructLineItemID,
  InstructionLineItem.amount,
  InstructionLineItem.unprocessedAmount,
  InstructionLineItem.instructLineItemCategory,
  InstructionLineItem.instructionLineItemType,
  InstructionLineItem.financialCompID,
  InstructionLineItem.coverPeriodFrom,
  InstructionLineItem.coverPeriodTo,
  InstructionLineItem.effectiveDate,
  InstructionLineItem.creationDate,
  InstructionLineItem.statusCode,
  InstructionLineItem.caseID,
  InstructionLineItem.finInstructionID,
  InstructionLineItem.concernRoleID,
  InstructionLineItem.caseNomineeID,
  InstructionLineItem.primaryClientID,
  InstructionLineItem.deliveryMethodType,
  InstructionLineItem.creditDebitType,
  InstructionLineItem.currencyExchangeID,
  InstructionLineItem.currencyTypeCode,
  InstructionLineItem.adjustmentInd,
  InstructionLineItem.adjustmentFrequency,
  InstructionLineItem.nextAdjustmentDate,
  InstructionLineItem.instrumentGenInd,
  InstructionLineItem.fundID,
  InstructionLineItem.maximumAmount,
  InstructionLineItem.versionNo,
  InstructionLineItem.dueDate,
  InstructionLineItem.inRespectOfID,
  InstructionLineItem.paymentGroupID,
  InCasePartRole.participantRoleID
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,
  :paymentGroupIDOpt,
  :nomineeParticipantRoleID 
FROM
  CaseNominee InputCaseNominee,
  CaseParticipantRole InCasePartRole,
  InstructionLineItem 
WHERE InCasePartRole.participantRoleID = :participantRoleID 
  AND InputCaseNominee.caseParticipantRoleID = InCasePartRole.caseParticipantRoleID 
  AND InstructionLineItem.caseNomineeID = InputCaseNominee.caseNomineeID 
  AND InstructionLineItem.statusCode = :statusCode 
  AND InstructionLineItem.instructLineItemCategory = :instructLineItemCategory 
ORDER BY InstructionLineItem.paymentGroupID,
  InstructionLineItem.currencyTypeCode,
  InstructionLineItem.deliveryMethodType,
  InstructionLineItem.caseID