Operation Details
Description: Returns the maximum percentage for the specified status, type, user name and product identifier.
Sterotype: ns
SQL 
SELECT
  DISTINCT (percentage) 
FROM
  EvidenceApprovalCheck 
WHERE typeCode = :typeCode 
  AND productID = :productID 
  AND userName = :userName 
  AND recordStatus = :recordStatus 
  AND percentage = 
  ( 
  SELECT
    MAX(percentage)
INTO
  :percentage 
  FROM
    EvidenceApprovalCheck 
  WHERE typeCode = :typeCode 
    AND productID = :productID 
    AND userName = :userName 
    AND recordStatus = :recordStatus 
  )