SELECT
  CaseHeader.caseID
INTO
  :caseID 
FROM
  CaseHeader,
  CaseParticipantRole 
WHERE CaseHeader.integratedCaseType = :integratedCaseType 
  AND CaseParticipantRole.participantRoleID = :concernRoleID 
  AND CaseHeader.caseID = CaseParticipantRole.caseID 
  AND CaseHeader.statusCode = :statusCode