Operation Details
Description: Returns the lowest Deduction priority. The lowest priority returned will be the highest numerical value i.e. in a list of deductions with priorities 1, 2, 3, 4, 5, the lowest priority would be 5.
Sterotype: ns
SQL 
SELECT
  MAX(priority)
INTO
  :priority 
FROM
  CaseDeductionItem 
WHERE caseID = :caseID 
  AND statusCode = :statusCode