Operation Details
Description: Method to check if a customer is in receipt of a SpendDown on a given date. If they are the spendDownID, status code and an indicator showing if the SpendDown period is met are returned.
Sterotype: ns
SQL 
SELECT
  statusCode,
  spendDownID,
  metInd
INTO
  :statusCode,
  :spendDownID,
  :metInd 
FROM
  ISPSpendDown 
WHERE ISPSpendDown.caseID = :caseID 
  AND ISPSpendDown.startDate <= :date 
  AND ISPSpendDown.endDate >= :date 
  AND ISPSpendDown.statusCode = :statusCode