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