Database SQL Operation: PaymentInstrument.searchConcernRolePaymentByConcernRoleID
Description: | Returns a list of payment instrument details for a participant. |
Sterotype: | nsmulti |
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
|