Operation Details
Description: This method returns all the unprocessed deductions against ILIs for the specified nominee
Sterotype: nsmulti
SQL 
SELECT
  deductionILI.instructLineItemID,
  deductionILI.amount,
  deductionILI.unprocessedAmount,
  deductionILI.instructLineItemCategory,
  deductionILI.instructionLineItemType,
  deductionILI.financialCompID,
  deductionILI.coverPeriodFrom,
  deductionILI.coverPeriodTo,
  deductionILI.effectiveDate,
  deductionILI.creationDate,
  deductionILI.statusCode,
  deductionILI.caseID,
  deductionILI.finInstructionID,
  deductionILI.concernRoleID,
  deductionILI.caseNomineeID,
  deductionILI.primaryClientID,
  deductionILI.deliveryMethodType,
  deductionILI.creditDebitType,
  deductionILI.currencyExchangeID,
  deductionILI.currencyTypeCode,
  deductionILI.adjustmentInd,
  deductionILI.adjustmentFrequency,
  deductionILI.nextAdjustmentDate,
  deductionILI.instrumentGenInd,
  deductionILI.fundID,
  deductionILI.maximumAmount,
  deductionILI.versionNo,
  deductionILI.dueDate,
  deductionILI.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 nomineeILI,
  InstructionLineItem deductionILI,
  InstructionLineItemRelation,
  CaseNominee,
  CaseParticipantRole 
WHERE CaseParticipantRole.participantRoleID = :participantRoleID 
  AND CaseNominee.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND nomineeILI.caseNomineeID = CaseNominee.caseNomineeID 
  AND InstructionLineItemRelation.instructLineItemID = nomineeILI.instructLineItemID 
  AND deductionILI.instructLineItemID = InstructionLineItemRelation.relatedLineItemID 
  AND deductionILI.instructLineItemCategory = :instructLineItemCategory 
  AND deductionILI.instructionLineItemType = :instructionLineItemType 
  AND deductionILI.statusCode = :statusCode 
  AND deductionILI.creditDebitType = :creditDebitType