Operation Details
Description: Operation to retrieve all rows from the Employer entity that match the specified methodOfPmtCode and where the nextPaymentDate is <= the input date.
Sterotype: nsmulti
SQL 
SELECT
  Employer.concernRoleID,
  Employer.registeredName,
  Employer.tradingName,
  Employer.industryType,
  Employer.companyType,
  Employer.businessDesc,
  Employer.specialInterestCode,
  Employer.exemptionInd,
  Employer.statusCode,
  Employer.comments,
  Employer.primaryAlternateID,
  Employer.numberPermanentStaff,
  Employer.numberCasualStaff,
  Employer.pinNumber,
  Employer.paymentFrequency,
  Employer.nextPaymentDate,
  Employer.currencyType,
  Employer.methodOfPmtCode,
  Employer.versionNo
INTO
  :concernRoleID,
  :registeredName,
  :tradingName,
  :industryType,
  :companyType,
  :businessDesc,
  :specialInterestCode,
  :exemptionInd,
  :statusCode,
  :comments,
  :primaryAlternateID,
  :numberPermanentStaff,
  :numberCasualStaff,
  :pinNumber,
  :paymentFrequency,
  :nextPaymentDate,
  :currencyType,
  :methodOfPmtCode,
  :versionNo 
FROM
  Employer 
WHERE Employer.methodOfPmtCode = :methodOfPmtCode 
  AND Employer.nextPaymentDate <= :nextPaymentDate