Operation Details
Description: This method retrieves a list of issue details using the related case ID.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseReference,
  CaseHeader.concernRoleID,
  IssueDelivery.issueType,
  IssueDelivery.resolutionStatus,
  CaseHeader.statusCode,
  CaseHeader.startDate,
  ConcernRole.concernRoleName,
  IssueDelivery.caseID
INTO
  :caseReference,
  :concernRoleID,
  :issueType,
  :resolutionStatus,
  :caseStatus,
  :startDate,
  :concernRoleName,
  :caseID 
FROM
  CaseHeader,
  IssueDelivery,
  ConcernRole 
WHERE IssueDelivery.relatedCaseID = :caseID 
  AND CaseHeader.caseID = IssueDelivery.caseID 
  AND ConcernRole.concernRoleID = CaseHeader.concernRoleID 
ORDER BY startDate DESC