Operation Details
Description: Retrieves a list of issue cases for an Integrated Case Member.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseReference,
  IssueDelivery.issueType,
  IssueDelivery.resolutionStatus,
  CaseHeader.statusCode,
  CaseHeader.startDate,
  IssueDelivery.caseID
INTO
  :caseReference,
  :issueType,
  :resolutionStatus,
  :caseStatus,
  :startDate,
  :caseID 
FROM
  CaseHeader,
  IssueDelivery,
  CaseParticipantRole 
WHERE CaseParticipantRole.caseParticipantRoleID = :caseParticipantRoleID 
  AND CaseParticipantRole.caseID = CaseHeader.integratedCaseID 
  AND CaseParticipantRole.participantRoleID = CaseHeader.concernRoleID 
  AND CaseHeader.caseTypeCode = :caseType 
  AND IssueDelivery.caseID = CaseHeader.caseID 
ORDER BY startDate DESC