Operation Details
Description: Returns the CaseID and Deadline Date for each appealed case which is associated with the specified appeal.
Sterotype: nsmulti
SQL 
SELECT
  AppealRelationship.caseID,
  deadlineDate
INTO
  :caseID,
  :deadlineDate 
FROM
  AppealRelationship,
  CaseHeader 
WHERE appealCaseID = :appealCaseID 
  AND recordStatus = :recordStatus 
  AND AppealRelationship.statusCode = :statusCode 
  AND AppealRelationship.caseID = CaseHeader.caseID