Operation Details
Description: Reads a product approval check for its percentage amount
Sterotype: ns
SQL 
SELECT
  percentage
INTO
  :percentage 
FROM
  CaseApprovalCheck 
WHERE percentage = 
  ( 
  SELECT
    MAX(percentage) 
  FROM
    CaseApprovalCheck 
  WHERE typeCode = :typeCode 
    AND productID = :productID 
    AND estimatedCost = :estimatedCost 
    AND statusCode = :statusCode 
  ) 
  AND typeCode = :typeCode 
  AND productID = :productID 
  AND estimatedCost = :estimatedCost 
  AND statusCode = :statusCode