Operation Details
Description: Search for appeal case details using the specified Case Reference.
Sterotype: nsmulti
SQL 
SELECT
  Appeal.caseID,
  caseReference,
  appealTypeCode,
  concernRoleName,
  participantRoleID,
  typeCode,
  concernRoleType,
  CaseHeader.registrationDate,
  CaseHeader.statusCode
INTO
  :caseID,
  :caseReference,
  :appealType,
  :participantName,
  :participantRoleID,
  :participantType,
  :concernRoleType,
  :creationDate,
  :status 
FROM
  Appeal,
  CaseHeader,
  CaseParticipantRole,
  ConcernRole 
WHERE CaseHeader.caseID = Appeal.caseID 
  AND CaseParticipantRole.caseID = Appeal.caseID 
  AND ConcernRole.concernRoleID = participantRoleID 
  AND typeCode in ( :appellantParticipantRoleType, :respondentParticipantRoleType) 
  AND caseReference = :caseReference 
ORDER BY caseReference,
  typeCode