SELECT
  Benefit.evidenceID,
  Benefit.benefitType,
  Benefit.startDate,
  Benefit.endDate,
  Benefit.frequencyCode,
  Benefit.amount
INTO
  :evidenceID,
  :benefitType,
  :startDate,
  :endDate,
  :frequencyCode,
  :amount 
FROM
  Benefit,
  CaseParticipantRole 
WHERE CaseParticipantRole.participantRoleID = :participantRoleID 
  AND CaseParticipantRole.caseID = :caseID 
  AND Benefit.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID