Operation Details
Description: To search Payment Received Instrument using amount and receivedDate
Sterotype: nsmulti
SQL 
SELECT
  PaymentReceivedInstrument.pmtRecInstrumentID,
  PaymentReceivedInstrument.amount,
  PaymentReceivedInstrument.receivedDate,
  PaymentReceivedInstrument.creationDate,
  PaymentReceivedInstrument.effectiveDate,
  PaymentReceivedInstrument.receiptMethodCode,
  PaymentReceivedInstrument.concernRoleID,
  PaymentReceivedInstrument.issuerName,
  PaymentReceivedInstrument.addressID,
  PaymentReceivedInstrument.currencyTypeCode,
  PaymentReceivedInstrument.currencyExchangeID,
  PaymentReceivedInstrument.depositSlipNumber,
  PaymentReceivedInstrument.receiptNumber,
  PaymentReceivedInstrument.liabilityExternalRefNo,
  PaymentReceivedInstruction.finInstructionID
INTO
  :pmtRecInstrumentID,
  :amount,
  :receivedDate,
  :creationDate,
  :effectiveDate,
  :receiptMethodCode,
  :concernRoleID,
  :issuerName,
  :addressID,
  :currencyTypeCode,
  :currencyExchangeID,
  :depositSlipNumber,
  :receiptNumber,
  :liabilityExternalRefNo,
  :finInstructionID 
FROM
  PaymentReceivedInstrument,
  PaymentReceivedInstruction 
WHERE PaymentReceivedInstrument.pmtRecInstrumentID = PaymentReceivedInstruction.pmtRecInstrumentID 
  AND PaymentReceivedInstrument.amount = :amount 
  AND PaymentReceivedInstrument.receivedDate = :receivedDate