SELECT
  AdminIntegratedCase.homePageName,
  AdminIntegratedCase.integratedCaseType,
  CaseHeader2.caseReference
INTO
  :homePageName,
  :integratedCaseType,
  :caseReference 
FROM
  CaseHeader CaseHeader1,
  CaseHeader CaseHeader2,
  AdminIntegratedCase 
WHERE CaseHeader1.caseID = :caseID 
  AND CaseHeader2.concernRoleID IS NOT NULL 
  AND AdminIntegratedCase.integratedCaseType = CaseHeader2.integratedCaseType 
  AND 
  (
    CaseHeader1.integratedCaseID = CaseHeader2.caseID 
    OR 
    (
      CaseHeader1.integratedCaseID IS NULL 
      AND CaseHeader2.caseID = :caseID 
    ) 
  )