Operation Details
Description: This method returns a list of spend down records within a specified date range based on the case id, met indicator and the spend down status code. The returned list is order based on the start dates of the records.
Sterotype: nsmulti
SQL 
SELECT
  spendDownID,
  startDate,
  endDate,
  dateOfApplication
INTO
  :spendDownID,
  :startDate,
  :endDate,
  :dateOfApplication 
FROM
  ISPSpendDown 
WHERE ISPSpendDown.caseID = :caseID 
  AND ISPSpendDown.startDate >= :startDate 
  AND 
  (
    ISPSpendDown.startDate <= :endDate 
    OR :endDate IS NULL 
  ) 
  AND ISPSpendDown.metInd = :metInd 
  AND ISPSpendDown.spendDownStatusCode = :spendDownStatusCode 
ORDER BY ISPSpendDown.startDate