SELECT
  appealProcessID
INTO
  :appealProcessID 
FROM
  AppealProcess 
WHERE recordStatus = :recordStatus 
  AND caseTypeID = :caseTypeID 
  AND startDate in 
  ( 
  SELECT
    MAX(startDate) AS startDate 
  FROM
    AppealProcess 
  WHERE recordStatus = :recordStatus 
    AND caseTypeID = :caseTypeID 
    AND startDate <= :startDate 
  )