[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';