SELECT
  CaseHeader.caseID,
  CaseHeader.caseReference,
  OrgObjectLink.orgObjectType,
  OrgObjectLink.orgObjectReference,
  OrgObjectLink.userName,
  ConcernRole.concernRoleName,
  CaseHeader.statusCode,
  CaseHeader.startDate
INTO
  :caseID,
  :caseReference,
  :orgObjectType,
  :orgObjectReference,
  :userName,
  :primaryClient,
  :status,
  :dateCreated 
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 
  AND IssueDelivery.issueType = :issueType 
ORDER BY startDate ASC