Operation Details
Description: Returns all issue deliveries for a specified concern role.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseReference,
  IssueDelivery.issueType,
  CaseHeader.statusCode,
  CaseHeader.startDate,
  IssueDelivery.caseID,
  CaseHeader.ownerOrgObjectLinkID
INTO
  :caseReference,
  :issueType,
  :caseStatus,
  :startDate,
  :caseID,
  :ownerOrgObjectLinkID 
FROM
  CaseHeader,
  IssueDelivery 
WHERE CaseHeader.concernRoleID = :concernRoleID 
  AND IssueDelivery.caseID = CaseHeader.caseID 
ORDER BY startDate DESC