Operation Details
Description:  
Sterotype: ns
SQL 
SELECT
  DeterminationDelivery1.determinationDeliveryID,
  DeterminationDelivery1.assessmentCaseID,
  DeterminationDelivery1.determinationConfigID,
  DeterminationDelivery1.determinationPackageVersionID,
  DeterminationDelivery1.status,
  DeterminationDelivery1.effectiveDate,
  DeterminationDelivery1.createdDateTime
INTO
  :determinationDeliveryID,
  :assessmentCaseID,
  :determinationConfigID,
  :determinationPackageVersionID,
  :status,
  :effectiveDate,
  :createdDateTime 
FROM
  DeterminationDelivery DeterminationDelivery1 
WHERE DeterminationDelivery1.createdDateTime = 
  ( 
  SELECT
    MAX(DeterminationDelivery2.createdDateTime) 
  FROM
    DeterminationDelivery DeterminationDelivery2 
  WHERE DeterminationDelivery2.assessmentCaseID = :assessmentCaseID 
  ) 
  AND DeterminationDelivery1.assessmentCaseID = :assessmentCaseID