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 >= :nextPmtDateFrom
AND Employer.nextPaymentDate <= :nextPmtDateTo
|