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
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 
FROM
  CaseDecisionFinancialComp,
  CaseDecisionObjective,
  InstructionLineItem 
WHERE CaseDecisionFinancialComp.caseDecisionObjectiveID = CaseDecisionObjective.caseDecisionObjectiveID 
  AND InstructionLineItem.financialCompID = CaseDecisionFinancialComp.financialCompID 
  AND CaseDecisionObjective.overflowInd = '0' 
  AND CaseDecisionObjective.relatedReference = :serviceInvoiceLineItemID