Operation Details
Description: Method to read the amount and the last updated date time by case id, status and max last updated date time.
Sterotype: ns
SQL 
SELECT
  ISPSpendDown.spendDownID,
  ISPSpendDown.amount,
  ISPSpendDown.lastUpdatedDateTime
INTO
  :spendDownID,
  :amount,
  :lastUpdatedDateTime 
FROM
  ISPSpendDown 
WHERE ISPSpendDown.caseID = :caseID 
  AND ISPSpendDown.statusCode = :statusCode 
  AND ISPSpendDown.lastUpdatedDateTime = ( 
  SELECT
    MAX(lastUpdatedDateTime) 
  FROM
    ISPSpendDown 
  WHERE ISPSpendDown.caseID = :caseID 
    AND ISPSpendDown.statusCode = :statusCode 
  )