SELECT
  EvidenceTypeDef.evidenceTypeDefID,
  EvidenceTypeDef.evidenceTypeCode
INTO
  :evidenceTypeDefID,
  :evidenceTypeCode 
FROM
  EvidenceTypeDef 
WHERE EvidenceTypeDef.recordStatus = :recordStatus 
  AND :productID NOT IN 
  ( 
  SELECT
    ProductEvidenceTypeDefLink.productID 
  FROM
    ProductEvidenceTypeDefLink 
  WHERE ProductEvidenceTypeDefLink.evidenceTypeDefID = EvidenceTypeDef.evidenceTypeDefID 
  )