Operation Details
Description: Searches all the Instruction Line Items for a provider roster line item.
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
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 = :providerRosterLineItemIDString