DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on AR_RECEIPT_METHODS

Line 4831: FROM AR_RECEIPT_METHODS

4827:
4828: CURSOR receipt_csr (pay_id NUMBER) IS
4829: SELECT
4830: name, nvl(merchant_ref, 0)
4831: FROM AR_RECEIPT_METHODS
4832: WHERE RECEIPT_METHOD_ID = pay_id
4833: AND SYSDATE >= NVL(START_DATE, SYSDATE)
4834: AND SYSDATE <= NVL(END_DATE, SYSDATE)
4835: AND PAYMENT_TYPE_CODE = 'CREDIT_CARD';