DBA Data[Home] [Help]

APPS.OE_VERIFY_PAYMENT_PUB dependencies on AR_RECEIPT_METHODS

Line 3016: FROM AR_RECEIPT_METHODS

3012: , merchant_ref
3013: INTO
3014: p_pay_method_name
3015: , p_merchant_ref
3016: FROM AR_RECEIPT_METHODS
3017: WHERE RECEIPT_METHOD_ID = p_pay_method_id
3018: AND SYSDATE >= NVL(START_DATE, SYSDATE)
3019: AND SYSDATE <= NVL(END_DATE, SYSDATE)
3020: AND PAYMENT_TYPE_CODE = 'CREDIT_CARD';

Line 4231: FROM AR_RECEIPT_METHODS

4227: , null
4228: INTO
4229: p_pay_method_name
4230: , p_merchant_id
4231: FROM AR_RECEIPT_METHODS
4232: WHERE RECEIPT_METHOD_ID = p_pay_method_id
4233: AND SYSDATE >= NVL(START_DATE, SYSDATE)
4234: AND SYSDATE <= NVL(END_DATE, SYSDATE)
4235: AND PAYMENT_TYPE_CODE = 'CREDIT_CARD';