SELECT
  COUNT(*)
INTO
  :count 
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 
  )