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