Operation Details
Description: To search for the completed determination delivery which has same effective date for the assessment
Sterotype: ns
SQL
SELECT
  determinationDeliveryID
INTO
  :determinationDeliveryID 
FROM
  DeterminationDelivery 
WHERE assessmentCaseID = 
  ( 
  SELECT
    assessmentCaseID 
  FROM
    DeterminationDelivery 
  WHERE determinationDeliveryID = :determinationDeliveryID 
  ) 
  AND status = :status 
  AND effectiveDate = :effectiveDate 
  AND determinationConfigID = 
  ( 
  SELECT
    determinationConfigID 
  FROM
    DeterminationDelivery 
  WHERE determinationDeliveryID = :determinationDeliveryID 
  )