| Operation Details |  |
| Description: | This operation counts the number of retroactive periods that exist for a case over a retroactive period. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT (*) INTO :recordCount FROM ISPSpendDown WHERE ISPSpendDown.caseID = :caseID AND ISPSpendDown.retroInd = :retroInd AND ISPSpendDown.startDate >= :retroStartDate |