SELECT
  DD1.effectiveDate,
  DD1.determinationDeliveryID,
  DD1.determinationConfigID,
  DD1.determinationPackageVersionID
INTO
  :effectiveDate,
  :determinationDeliveryID,
  :determinationConfigID,
  :determinationPackageVersionID 
FROM
  DeterminationDelivery DD1 
WHERE DD1.effectiveDate = 
  ( 
  SELECT
    MAX(DD2.effectiveDate) 
  FROM
    DeterminationDelivery DD2 
  WHERE DD2.determinationDeliveryID = DD1.determinationDeliveryID 
  ) 
  AND DD1.assessmentCaseID = :assessmentCaseID