Operation Details
Description: Method to return Instruction Line Item records with caseNominee details based on concernRoleID, instructLineItemCategory 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.dueDate,
  InstructionLineItem.inRespectOfID,
  InstructionLineItem.versionNo
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,
  :dueDate,
  :inRespectOfID,
  :versionNo 
FROM
  InstructionLineItem,
  CaseNominee 
WHERE InstructionLineItem.concernRoleID = :concernRoleID 
  AND InstructionLineItem.instructLineItemCategory = :instructLineItemCategory 
  AND InstructionLineItem.statusCode = :statusCode 
  AND InstructionLineItem.caseNomineeID = CaseNominee.caseNomineeID 
ORDER BY InstructionLineItem.concernRoleID,
  InstructionLineItem.instructLineItemCategory,
  InstructionLineItem.statusCode