SELECT
  Appellant.caseParticipantRoleID
INTO
  :caseParticipantRoleID 
FROM
  Appellant,
  Appeal,
  CaseParticipantRole 
WHERE Appeal.caseID = :appealCaseID 
  AND Appellant.appealID =Appeal.appealID 
  AND Appellant.receiptNoticeIndicator = :receiptNoticeInd 
  AND Appellant.toDate IS NULL 
  AND CaseParticipantRole.caseParticipantRoleID =Appellant.caseParticipantRoleID