Operation Details
Description: Gets the List of Status, Effective Date form Determination Delivery, Name, Type form Determination Configuration
Sterotype: nsmulti
SQL 
SELECT
  DeterminationDelivery.determinationDeliveryID,
  DeterminationDelivery.status,
  DeterminationDelivery.effectiveDate,
  DeterminationConfig.name,
  DeterminationConfig.type
INTO
  :determinationDeliveryID,
  :status,
  :effectiveDate,
  :determinationName,
  :determinationType 
FROM
  DeterminationDelivery,
  DeterminationConfig 
WHERE assessmentCaseID = :assessmentCaseID 
  AND DeterminationConfig.determinationConfigID = DeterminationDelivery.determinationConfigID 
ORDER BY type,
  effectiveDate DESC