SELECT
  IssueDelivery.caseID,
  CaseHeader.caseReference,
  OrgObjectLink.orgObjectType,
  OrgObjectLink.orgObjectReference,
  OrgObjectLink.userName,
  ConcernRole.concernRoleName,
  IssueDelivery.issueType,
  CaseHeader.statusCode,
  CaseHeader.startDate
INTO
  :caseID,
  :caseReference,
  :orgObjectType,
  :orgObjectReference,
  :userName,
  :primaryClient,
  :issueType,
  :caseStatus,
  :startDate 
FROM
  CaseHeader,
  ConcernRole,
  IssueDelivery,
  OrgObjectLink 
WHERE CaseHeader.caseID = IssueDelivery.caseID 
  AND CaseHeader.concernRoleID = ConcernRole.concernRoleID 
  AND CaseHeader.ownerOrgObjectLinkID = OrgObjectLink.orgObjectLinkID 
  AND CaseHeader.statusCode <> :caseStatus 
  AND IssueDelivery.relatedCaseID = :caseID 
ORDER BY startDate ASC