Operation Details
Description: Returns a list of all current SpendDown periods for a case.
Sterotype: nsmulti
SQL 
SELECT
  spendDownID,
  endDate,
  startDate,
  statusCode,
  amount,
  outstandingAmount,
  metInd,
  coverageStartDate,
  lastUpdatedDateTime,
  caseID
INTO
  :spendDownID,
  :endDate,
  :startDate,
  :statusCode,
  :amount,
  :outstandingAmount,
  :metInd,
  :coverageStartDate,
  :lastUpdatedDateTime,
  :caseID 
FROM
  ISPSpendDown 
WHERE ISPSpendDown.caseID = :caseID 
  AND ISPSpendDown.statusCode = :statusCode 
ORDER BY ISPSpendDown.startDate DESC,
  ISPSpendDown.statusCode ASC,
  ISPSpendDown.lastUpdatedDateTime DESC