Operation Details
Description: Returns a list of payment instrument details for a participant.
Sterotype: nsmulti
SQL
SELECT
  pmtInstrumentID,
  effectiveDate,
  deliveryMethodType,
  amount,
  reconcilStatusCode
INTO
  :pmtInstrumentID,
  :effectiveDate,
  :deliveryMethodType,
  :amount,
  :reconcilStatusCode 
FROM
  PaymentInstrument 
WHERE concernRoleID = :concernRoleID 
  AND caseNomineeID IS NULL 
  AND reconcilStatusCode = :reconcilStatusCode 
ORDER BY effectiveDate