| Operation Details |  |
| Description: | To search the PaymentInstrument using the delivery method code, the status code and the effective date < the input effective date |
| Sterotype: | nsmulti |
| SQL | |
SELECT pmtInstrumentID, amount, effectiveDate, deliveryMethodType, concernRoleID, concernRoleName, nomineeName, addressID, versionNo INTO :pmtInstrumentID, :amount, :effectiveDate, :deliveryMethodType, :concernRoleID, :concernRoleName, :nomineeName, :addressID, :versionNo FROM PaymentInstrument WHERE PaymentInstrument.reconcilStatusCode = :reconcilStatusCode AND PaymentInstrument.deliveryMethodType = :deliveryMethodType AND PaymentInstrument.effectiveDate < :effectiveDate |