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