SELECT
  Appellant.appellantID,
  Appellant.appellantTypeCode,
  Appellant.fromDate,
  Appellant.toDate,
  Appellant.receiptNoticeIndicator,
  ConcernRole.concernRoleName
INTO
  :appellantID,
  :appellantTypeCode,
  :fromDate,
  :toDate,
  :receiptNoticeIndicator,
  :appellantName 
FROM
  Appellant,
  CaseParticipantRole,
  ConcernRole 
WHERE Appellant.appealID = :appealID 
  AND Appellant.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID