SELECT
  count(*)
INTO
  :numberOfRecords 
FROM
  HearingParticipation,
  CaseParticipantRole 
WHERE hearingID = 
  ( 
  SELECT
    hearingID 
  FROM
    Hearing 
  WHERE scheduledDateTime = 
    ( 
    SELECT
      max(scheduledDateTime) 
    FROM
      Hearing 
    WHERE caseID = :caseID 
    ) 
    AND caseID = :caseID 
  ) 
  AND participatedCode = :statusCode 
  AND HearingParticipation.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND CaseParticipantRole.typeCode = :participantType