DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on AR_RECEIPT_METHODS

Line 4684: FROM AR_RECEIPT_METHODS

4680:
4681: CURSOR receipt_csr (pay_id NUMBER) IS
4682: SELECT
4683: name, nvl(merchant_ref, 0)
4684: FROM AR_RECEIPT_METHODS
4685: WHERE RECEIPT_METHOD_ID = pay_id
4686: AND SYSDATE >= NVL(START_DATE, SYSDATE)
4687: AND SYSDATE <= NVL(END_DATE, SYSDATE)
4688: AND PAYMENT_TYPE_CODE = 'CREDIT_CARD';