Operation Details
Description: Returns the lowest provider 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 and 5, the lowest priority would be 5.
Sterotype: ns
SQL 
SELECT
  MAX(priority)
INTO
  :priority 
FROM
  ProviderDeduction
WHERE providerConcernRoleID = :providerConcernRoleID
  AND recordStatus = :recordStatus