| Operation Details |  |
| Description: | List all spendDown periods that are current, and have a endDate later than the endDate entered. |
| Sterotype: | nsmulti |
| SQL | |
SELECT ISPSpendDown.spendDownID INTO :spendDownID FROM ISPSpendDown WHERE ISPSpendDown.caseID = :caseID AND ISPSpendDown.statusCode = :statusCode AND ISPSpendDown.endDate > :endDate |