Operation Details
Description: Operation to retrieve all rows from the Person entity that match the specified methodOfPmtCode and where the nextPaymentDate is between the specified date range.
Sterotype: nsmulti
SQL 
SELECT
  Person.concernRoleID,
  Person.personBirthName,
  Person.dateOfBirth,
  Person.dateOfDeath,
  Person.gender,
  Person.specialInterestCode,
  Person.maritalStatusCode,
  Person.nationalityCode,
  Person.residencyAbroadInd,
  Person.motherBirthSurname,
  Person.comments,
  Person.type,
  Person.dateOfBirthVerInd,
  Person.dateOfDeathVerInd,
  Person.primaryAlternateID,
  Person.countryOfBirth,
  Person.placeOfBirth,
  Person.pinNumber,
  Person.primaryAlternateNameID,
  Person.ethnicOriginCode,
  Person.paymentFrequency,
  Person.nextPaymentDate,
  Person.currencyType,
  Person.methodOfPmtCode,
  Person.versionNo
INTO
  :concernRoleID,
  :personBirthName,
  :dateOfBirth,
  :dateOfDeath,
  :gender,
  :specialInterestCode,
  :maritalStatusCode,
  :nationalityCode,
  :residencyAbroadInd,
  :motherBirthSurname,
  :comments,
  :type,
  :dateOfBirthVerInd,
  :dateOfDeathVerInd,
  :primaryAlternateID,
  :countryOfBirth,
  :placeOfBirth,
  :pinNumber,
  :primaryAlternateNameID,
  :ethnicOriginCode,
  :paymentFrequency,
  :nextPaymentDate,
  :currencyType,
  :methodOfPmtCode,
  :versionNo 
FROM
  Person 
WHERE Person.methodOfPmtCode = :methodOfPmtCode 
  AND Person.nextPaymentDate >= :nextPmtDateFrom 
  AND Person.nextPaymentDate <= :nextPmtDateTo