SELECT
  IssueDelivery.issueType,
  count(IssueDelivery.caseID) issueCount
INTO
  :issueType,
  :count 
FROM
  CaseHeader,
  IssueDelivery 
WHERE IssueDelivery.relatedCaseID = :caseID 
  AND CaseHeader.caseID = IssueDelivery.caseID 
  AND CaseHeader.statusCode <> :caseStatusCode 
GROUP
  BY IssueDelivery.issueType 
ORDER BY issueCount DESC