SELECT
  evidenceDescriptorID
INTO
  :evidenceDescriptorID 
FROM
  EvidenceDescriptor 
WHERE caseID = :caseID 
  AND evidenceType = :evidenceType 
  AND relatedID = :evidenceID 
  AND 
  (
    statusCode = :statusCode1 
    OR statusCode = :statusCode2 
  )