Operation Details
Description: Returns all appeals for a specified concern role.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseReference,
  Appeal.appealTypeCode,
  CaseHeader.statusCode,
  CaseHeader.startDate,
  Appeal.caseID,
  CaseHeader.ownerOrgObjectLinkID
INTO
  :caseReference,
  :appealType,
  :caseStatus,
  :startDate,
  :caseID,
  :ownerOrgObjectLinkID 
FROM
  CaseHeader,
  Appeal,
  ConcernRole,
  CaseParticipantRole,
  Appellant 
WHERE ConcernRole.concernRoleID = :concernRoleID 
  AND CaseParticipantRole.participantRoleID = ConcernRole.concernRoleID 
  AND Appellant.caseParticipantRoleID = CaseParticipantRole.caseParticipantRoleID 
  AND Appellant.appealID = Appeal.appealID 
  AND Appeal.caseID = CaseHeader.caseID 
ORDER BY startDate DESC