SELECT
  AppealProcess.appealProcessID,
  AppealProcess.startDate,
  AppealProcess.recordStatus,
  AppealStageConfiguration.appealTypeCode AS firstStage,
  AppealStageConfiguration.recordStatus AS firstStageRecordStatus
INTO
  :appealProcessID,
  :startDate,
  :status,
  :firstStage,
  :firstStageRecordStatus 
FROM
  AppealProcess 
  
  LEFT 
  
  JOIN
  
  AppealStageConfiguration 
  ON AppealStageConfiguration.appealProcessID = appealProcess.appealProcessID 
  AND AppealStageConfiguration.parentStageConfID IS NULL 
WHERE appealProcess.caseTypeID = :caseTypeID 
  AND appealProcess.caseType = :caseType 
ORDER BY AppealProcess.startDate DESC