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 
WHERE nomineeILI.caseNomineeID = :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