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