Operation Details
Description: Reads User 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 userName = :userName 
    AND estimatedCost = :estimatedCost 
    AND statusCode = :statusCode 
  ) 
  AND typeCode = :typeCode 
  AND userName = :userName 
  AND estimatedCost = :estimatedCost 
  AND statusCode = :statusCode