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,
    PositionHolderLink,
    Position,
    OrganisationUnit,
    OrgUnitPositionLink 
  WHERE PositionHolderLink.userName = :userName 
    AND Position.positionID = PositionHolderLink.positionID 
    AND 
    (
      
      (
        OrgUnitPositionLink.organisationUnitID = OrganisationUnit.organisationUnitID 
      ) 
      AND 
      (
        OrgUnitPositionLink.positionID = Position.positionID 
      ) 
    ) 
    AND EvidenceApprovalCheck.typeCode = :typeCode 
    AND EvidenceApprovalCheck.productID = :productID 
    AND EvidenceApprovalCheck.recordStatus = :recordStatus 
  )