SELECT
  name,
  productID
INTO
  :name,
  :productID 
FROM
  Product 
WHERE productID <> :productID 
  AND statusCode = :recordStatus 
  AND productID IN 
  ( 
  SELECT
    productID 
  FROM
    ProductEvidenceLink 
  WHERE evidenceMetadataID IN 
    ( 
    SELECT
      evidenceMetadataID 
    FROM
      EvidenceMetadata 
    WHERE evidenceType = :evidenceType 
      AND recordStatus = :recordStatus 
    ) 
  )