Database SQL Operation: Provider.searchPaymentInstrumentByCaseNominee
Description: | Searches and returns a list of all payment instruments that match the case nominee entered. |
Sterotype: | nsmulti |
SELECT
PaymentInstrument.amount,
PaymentInstrument.currencyTypeCode,
PaymentInstrument.effectiveDate,
PaymentInstrument.pmtInstrumentID,
PaymentInstrument.creationDate,
PaymentInstrument.reconcilStatusCode
INTO
:amount,
:currencyTypeCode,
:effectiveDate,
:pmtInstrumentID,
:creationDate,
:reconcilStatusCode
FROM
PaymentInstrument
WHERE PaymentInstrument.caseNomineeID = :caseNomineeID
|