SELECT
  evidenceDescriptorID,
  EvidenceDescriptor.participantID,
  evidenceType
INTO
  :evidenceDescriptorID,
  :participantID,
  :evidenceType
FROM
  EvidenceDescriptor, CaseParticipantRole
WHERE EvidenceDescriptor.caseID = :caseID 
  AND EvidenceDescriptor.participantID = CaseParticipantRole.participantRoleID 
  AND ( CaseParticipantRole.typeCode = :caseParticipantRoleType1 OR CaseParticipantRole.typeCode = :caseParticipantRoleType2 ) 
  AND EvidenceDescriptor.statusCode = :evidenceDescStatus
  AND CaseParticipantRole.caseID = :productCaseID