Operation Details
Description: Reads for the active appeal cases appealing the specified implementation case
Sterotype: nsmulti
SQL 
SELECT
  appealID
INTO
  :appealID 
FROM
  Appeal,
  CaseHeader,
  AppealRelationship 
WHERE Appeal.caseID = AppealRelationship.appealCaseID 
  AND AppealRelationship.caseID = :implCaseID 
  AND 
  (
    CaseHeader.statusCode = :activeStatusCode 
    OR CaseHeader.statusCode = :openStatusCode 
    OR CaseHeader.statusCode = :approvedStatusCode 
  )