Operation Details
Description: Operation to retrieve all rows from the Utility entity that match the specified methodOfPmtCode and where the nextPaymentDate is between the specified date range.
Sterotype: nsmulti
SQL 
SELECT
  Utility.concernRoleID,
  Utility.name,
  Utility.registeredName,
  Utility.utilityTypeCode,
  Utility.methodOfPmtCode,
  Utility.paymentFrequency,
  Utility.statusCode,
  Utility.comments,
  Utility.primaryAlternateID,
  Utility.maximumPaymentRate,
  Utility.minimumPaymentAmount,
  Utility.nextPaymentDate,
  Utility.versionNo
INTO
  :concernRoleID,
  :name,
  :registeredName,
  :utilityTypeCode,
  :methodOfPmtCode,
  :paymentFrequency,
  :statusCode,
  :comments,
  :primaryAlternateID,
  :maximumPaymentRate,
  :minimumPaymentAmount,
  :nextPaymentDate,
  :versionNo 
FROM
  Utility 
WHERE Utility.methodOfPmtCode = :methodOfPmtCode 
  AND Utility.nextPaymentDate >= :nextPmtDateFrom 
  AND Utility.nextPaymentDate <= :nextPmtDateTo