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