SELECT
  AR.appealRelationshipID,
  AR.priorAppealCaseID AS caseID,
  CH.caseReference,
  ID.issueType,
  AR.resolutionCode,
  '1' AS priorAppealIndicator
INTO
  :appealRelationshipID,
  :caseID,
  :referenceNumber,
  :issueType,
  :resolutionCode,
  :priorAppealIndicator 
FROM
  AppealRelationship AR,
  CaseHeader CH,
  IssueDelivery ID 
WHERE AR.appealCaseID = :appealCaseID 
  AND AR.recordStatus = :recordStatus 
  AND AR.priorAppealCaseID = CH.caseID 
  AND CH.caseTypeCode ='CT10' 
  AND AR.priorAppealCaseID = ID.caseID 
  AND AR.priorAppealCaseID IS NOT NULL 

UNION
  
SELECT
  AR.appealRelationshipID,
  AR.caseID,
  CH.caseReference,
  ID.issueType,
  AR.resolutionCode,
  '0' AS priorAppealIndicator 
FROM
  AppealRelationship AR,
  CaseHeader CH,
  IssueDelivery ID 
WHERE AR.appealCaseID = :appealCaseID 
  AND AR.recordStatus = :recordStatus 
  AND AR.caseID = CH.caseID 
  AND CH.caseTypeCode ='CT10' 
  AND AR.priorAppealCaseID IS NULL