SELECT
  caseID,
  caseTypeCode
INTO
  :caseID,
  :caseType 
FROM
  CaseHeader 
WHERE integratedCaseID = :caseID 
  AND concernRoleID = :concernRoleID 
  AND statusCode <> :statusCode