Operation Details
Description: To read the sum of the amount field based on CaseID, FinInstructID, Category and Status.
Sterotype: ns
SQL
SELECT
  SUM(amount)
INTO
  :amount 
FROM
  InstructionLineItem 
WHERE InstructionLineItem.caseID = :caseID 
  AND InstructionLineItem.finInstructionID = :finInstructionID 
  AND InstructionLineItem.instructLineItemCategory = :instructLineItemCategory 
  AND InstructionLineItem.statusCode = :statusCode