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