SELECT
  parentID,
  parentType
INTO
  :parentID,
  :parentType 
FROM
  EvidenceRelationship 
WHERE childID = :childID 
  AND childType = :childType 
  AND parentID in 
  ( 
  SELECT
    relatedID 
  FROM
    EvidenceDescriptor 
  WHERE relatedID = parentID 
    AND 
    (
      statusCode = :statusCode1 
      OR statusCode = :statusCode2 
      OR statusCode = :statusCode3 
      OR statusCode = :statusCode4Opt
    ) 
  )