Operation Details
Description: Returns all appeals process for a product including the first stage in the appeal process if any.
Sterotype: nsmulti
SQL 
SELECT
  ProductAppealProcess.productAppealProcessID,
  ProductAppealProcess.startDate,
  ProductAppealProcess.recordStatus,
  AppealStage.appealTypeCode AS firstStage,
  AppealStage.recordStatus AS firstStageRecordStatus
INTO
  :productAppealProcessID,
  :startDate,
  :recordStatus,
  :firstStage,
  :firstStageRecordStatus 
FROM
  ProductAppealProcess 
  
  LEFT 
  
  JOIN
  
  AppealStage 
  ON AppealStage.productAppealProcessID = ProductAppealProcess.productAppealProcessID 
  AND AppealStage.parentAppealStageID IS NULL 
WHERE ProductAppealProcess.productID = :productID