Operation Details
Description: Returns amounts from all Financial Instruction records of specified type that have one of the two statuses required and belong to the specified case.
Sterotype: nsmulti
SQL 
SELECT
  amount
INTO
  :amount 
FROM
  FinancialInstruction 
WHERE 
  (
    FinancialInstruction.finInstructionID in 
    ( 
    SELECT
      DISTINCT finInstructionID 
    FROM
      InstructionLineItem 
    WHERE InstructionLineItem.caseID = :caseID 
    ) 
  ) 
  AND FinancialInstruction.creditDebitType = :creditDebitType 
  AND 
  (
    FinancialInstruction.statusCode = :statusCode1 
    OR FinancialInstruction.statusCode = :statusCode2 
  )