Operation Details
Description: Returns deduction name, priority and version number. This information can then be used by the user if they decide to modify a deduction product link record.
Sterotype: ns
SQL 
SELECT
  Deduction.deductionName,
  DeductionProductLink.priority,
  DeductionProductLink.preventOverlappingInd,
  DeductionProductLink.versionNo
INTO
  :deductionName,
  :priority,
  :preventOverlappingIndOpt,
  :versionNo 
FROM
  Deduction,
  DeductionProductLink 
WHERE DeductionProductLink.deductionProductLinkID = :deductionProductLinkID 
  AND DeductionProductLink.deductionID = Deduction.deductionID