Operation Details
Description: Returns a list of related appeal cases for a caseID
Sterotype: nsmulti
SQL 
SELECT
  Appeal.caseID,
  CaseHeader.caseReference,
  Appeal.appealTypeCode,
  CaseHeader.ownerOrgObjectLinkID,
  CaseHeader.statusCode,
  CaseHeader.receivedDate,
  Appeal.deadlineDate
INTO
  :caseID,
  :caseReference,
  :appealTypeCode,
  :ownerOrgObjectLinkID,
  :statusCode,
  :receivedDate,
  :deadlineDate 
FROM
  Appeal,
  CaseHeader,
  CaseRelationship 
WHERE Appeal.caseID = CaseHeader.caseID 
  AND CaseHeader.caseID = CaseRelationship.relatedCaseID 
  AND CaseRelationship.caseID = :caseID 
  AND CaseRelationship.reasonCode = :reasonCode 
  AND CaseRelationship.typeCode = :typeCode