Operation Details
Description: Operation to retrieve all ProductProvider records that match the specified methodOfPmtCode and where the nextPaymentDate is <= the input date
Sterotype: nsmulti
SQL 
SELECT
  ProductProvider.concernRoleID,
  ProductProvider.name,
  ProductProvider.registeredName,
  ProductProvider.statusCode,
  ProductProvider.comments,
  ProductProvider.primaryAlternateID,
  ProductProvider.nextPaymentDate,
  ProductProvider.paymentFrequency,
  ProductProvider.methodOfPmtCode,
  ProductProvider.versionNo
INTO
  :concernRoleID,
  :name,
  :registeredName,
  :statusCode,
  :comments,
  :primaryAlternateID,
  :nextPaymentDate,
  :paymentFrequency,
  :methodOfPmtCode,
  :versionNo 
FROM
  ProductProvider 
WHERE ProductProvider.methodOfPmtCode = :methodOfPmtCode 
  AND ProductProvider.nextPaymentDate <= :nextPaymentDate