Operation Details |
Description: | To calculate the sum of the unprocessedAmount field for one CreditDebitType for a Case. |
Sterotype: | ns |
SQL |
SELECT SUM(unprocessedAmount) INTO :amount FROM InstructionLineItem WHERE caseID = :caseID AND creditDebitType = :creditDebitType |