SELECT
  ScheduleReassessment.scheduledReassessmentID,
  ScheduleReassessment.caseID,
  ScheduleReassessment.fromDate,
  ScheduleReassessment.toDate,
  ScheduleReassessment.versionNo,
  CaseHeader.caseReference
INTO
  :scheduledReassessmentID,
  :caseID,
  :fromDate,
  :toDate,
  :versionNo,
  :caseReference 
FROM
  ScheduleReassessment,
  CaseHeader 
WHERE ScheduleReassessment.caseID = CaseHeader.caseID