Operation Details
Description: Reads date of application and start date of the most recent spend down period after the given date that matches caseID, metInd and retroInd.
Sterotype: nsmulti
SQL 
SELECT
  ISPSpendDown.startDate,
  ISPSpendDown.dateOfApplication
INTO
  :startDate,
  :dateOfApplication 
FROM
  ISPSpendDown 
WHERE ISPSpendDown.caseID = :caseID 
  AND ISPSpendDown.metInd = :metInd 
  AND ISPSpendDown.retroInd = :retroInd 
  AND ISPSpendDown.startDate >= :startDate 
ORDER BY ISPSpendDown.startDate ASC