SELECT
  ProductEvidenceTypeDefLink.productEvidenceTypeDefLinkID,
  ProductEvidenceTypeDefLink.evidenceTypeDefID
INTO
  :productEvidenceTypeDefLinkID,
  :evidenceTypeDefID
FROM
  ProductEvidenceTypeDefLink,
  EvidenceTypeDef
WHERE ProductEvidenceTypeDefLink.productID = :productID
  AND EvidenceTypeDef.evidenceTypeDefID = ProductEvidenceTypeDefLink.evidenceTypeDefID
  AND EvidenceTypeDef.recordStatus = :recordStatus