SQL:ISPEligibilityDateRangeProc.readMaxCurrentPeriodCountByReqInstIdentifier

Database SQL Operation: ISPEligibilityDateRangeProc.readMaxCurrentPeriodCountByReqInstIdentifier

Operation Details

Description:	Returns the max value of currentPeriodCount field for the provided requestInstanceIdentifier.
Sterotype:	ns

SQL

SELECT
  MAX(currentPeriodCount)
INTO
  :maxCount 
FROM
  ISPEligibilityDateRangeProc 
WHERE requestInstanceIdentifier = :requestInstanceIdentifier