SELECT
  CaseHeader.caseReference,
  ServicePlan.servicePlanType,
  CaseHeader.statusCode,
  CaseHeader.startDate,
  ServicePlanDelivery.caseID,
  CaseHeader.ownerOrgObjectLinkID
INTO
  :caseReference,
  :servicePlanType,
  :caseStatus,
  :startDate,
  :caseID,
  :ownerOrgObjectLinkID 
FROM
  CaseHeader,
  ServicePlan,
  ServicePlanDelivery 
WHERE CaseHeader.concernRoleID = :concernRoleID 
  AND ServicePlan.servicePlanID = ServicePlanDelivery.servicePlanID 
  AND ServicePlanDelivery.caseID = CaseHeader.caseID 
ORDER BY startDate DESC