SELECT
  Appellant.appellantID,
  Appellant.appellantTypeCode,
  Appellant.fromDate,
  Appellant.toDate,
  Appellant.receiptNoticeIndicator,
  OrganisationUnit.name
INTO
  :appellantID,
  :appellantTypeCode,
  :fromDate,
  :toDate,
  :receiptNoticeIndicator,
  :appellantName 
FROM
  Appellant,
  OrganisationUnit 
WHERE Appellant.appealID = :appealID 
  AND Appellant.caseParticipantRoleID = OrganisationUnit.organisationUnitID