Database SQL Operation: PaymentCancellationRequest.searchByTypeCodeDateRange
Description: | Returns payment cancellation request records based on the search criteria, typeCode, creationFromDate and creationToDate passed in. |
Sterotype: | nsmulti |
SELECT
pmtInstrumentID,
creationDate,
reasonText,
typeCode,
pmtCancellationID,
versionNo
INTO
:pmtInstrumentID,
:creationDate,
:reasonText,
:typeCode,
:pmtCancellationID,
:versionNo
FROM
PaymentCancellationRequest
WHERE typeCode = :typeCode
AND creationDate >= :creationFromDate
AND creationDate <= :creationToDate
|