Operation Details
Description: Operation to retrieve all rows from the Representative entity that match the specified methodOfPmtCode and where the nextPaymentDate is between the specified date range.
Sterotype: nsmulti
SQL 
SELECT
  Representative.concernRoleID,
  Representative.representativeName,
  Representative.representativeType,
  Representative.alternateID,
  Representative.comments,
  Representative.paymentFrequency,
  Representative.nextPaymentDate,
  Representative.currencyType,
  Representative.methodOfPmtCode,
  Representative.dateOfBirth,
  Representative.versionNo
INTO
  :concernRoleID,
  :representativeName,
  :representativeType,
  :alternateID,
  :comments,
  :paymentFrequency,
  :nextPaymentDate,
  :currencyType,
  :methodOfPmtCode,
  :dateOfBirth,
  :versionNo 
FROM
  Representative 
WHERE Representative.methodOfPmtCode = :methodOfPmtCode 
  AND Representative.nextPaymentDate >= :nextPmtDateFrom 
  AND Representative.nextPaymentDate <= :nextPmtDateTo