Operation Details
Description: Returns payment cancellation request records based on the search criteria, typeCode, creationFromDate and creationToDate passed in.
Sterotype: nsmulti
SQL
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