Operation Details |
Description: | Method to read the current spendDown period's start date based on the caseID the current date. |
Sterotype: | ns |
SQL |
SELECT MAX(startDate) INTO :currentStartDate FROM ISPSpendDown WHERE ISPSpendDown.caseID = :caseID AND ISPSpendDown.startDate <= :currentDate |