DBA Data[Home] [Help]

APPS.OE_VERIFY_PAYMENT_PUB dependencies on AR_RECEIPT_METHODS

Line 3089: FROM AR_RECEIPT_METHODS

3085: , merchant_ref
3086: INTO
3087: p_pay_method_name
3088: , p_merchant_ref
3089: FROM AR_RECEIPT_METHODS
3090: WHERE RECEIPT_METHOD_ID = p_pay_method_id
3091: AND SYSDATE >= NVL(START_DATE, SYSDATE)
3092: AND SYSDATE <= NVL(END_DATE, SYSDATE)
3093: AND PAYMENT_TYPE_CODE = 'CREDIT_CARD';

Line 4304: FROM AR_RECEIPT_METHODS

4300: , null
4301: INTO
4302: p_pay_method_name
4303: , p_merchant_id
4304: FROM AR_RECEIPT_METHODS
4305: WHERE RECEIPT_METHOD_ID = p_pay_method_id
4306: AND SYSDATE >= NVL(START_DATE, SYSDATE)
4307: AND SYSDATE <= NVL(END_DATE, SYSDATE)
4308: AND PAYMENT_TYPE_CODE = 'CREDIT_CARD';