SELECT
  ScreeningConfiguration.name,
  CaseHeader.caseReference
INTO
  :name,
  :caseReference 
FROM
  ScreeningConfiguration,
  Screening,
  CaseHeader 
WHERE Screening.caseID = :caseID 
  AND CaseHeader.caseID = Screening.caseID 
  AND ScreeningConfiguration.screeningConfigID = Screening.screeningConfigID