Operation Details
Description: Returns a list of active deductions not associated with a particular product.
Sterotype: nsmulti
SQL 
SELECT
  deductionID,
  deductionName,
  priority,
  dateCreated
INTO
  :deductionID,
  :deductionName,
  :priority,
  :dateCreated 
FROM
  Deduction 
WHERE deductionID NOT IN 
  ( 
  SELECT
    deductionID 
  FROM
    DeductionProductLink 
  WHERE productID = :productID 
  ) 
  AND recordStatus = :recordStatus 
ORDER BY priority