Operation Details
Description: Returns a list of deduction details associated with a particular product and deduction category.
Sterotype: nsmulti
SQL 
SELECT
  Deduction.deductionID,
  Deduction.deductionName,
  Deduction.category,
  DeductionProductLink.priority
INTO
  :deductionID,
  :deductionName,
  :category,
  :priority 
FROM
  DeductionProductLink,
  Deduction 
WHERE DeductionProductLink.productID = :productID 
  AND DeductionProductLink.deductionID = Deduction.deductionID 
  AND Deduction.category = :category 
ORDER BY DeductionProductLink.priority