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