SELECT
  productAppealProcessID
INTO
  :productAppealProcessID 
FROM
  ProductAppealProcess 
WHERE recordStatus = :recordStatus 
  AND productID = :productID 
  AND startDate in 
  ( 
  SELECT
    MAX(startDate) AS startDate 
  FROM
    ProductAppealProcess 
  WHERE recordStatus = :recordStatus 
    AND productID = :productID 
    AND startDate <= :startDate 
  )