SELECT
  COUNT(*)
INTO
  :numberOfRecords 
FROM
  ProductEvidenceLink 
WHERE evidenceMetadataID IN 
  ( 
  SELECT
    evidenceMetadataID 
  FROM
    EvidenceMetadata 
  WHERE evidenceType = :evidenceType 
    AND recordStatus = :recordStatus 
  )