DBA Data[Home] [Help]

APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on OE_PAYMENTS

Line 3085: FROM oe_payments

3081:
3082: BEGIN
3083: SELECT payment_number
3084: INTO l_hd_payment_tbl(j).PAYMENT_REF_NUMBER
3085: FROM oe_payments
3086: WHERE header_id =l_order_header_id
3087: AND payment_level_code ='ORDER'
3088: AND payment_type_code ='CREDIT_CARD'
3089: AND PAYMENT_COLLECTION_EVENT='INVOICE';

Line 3119: FROM oe_payments

3115: nvl(fnd_profile.value('CS_CC_TO_OM_HEADER'),'N') = 'Y' then
3116: BEGIN
3117: SELECT payment_number
3118: INTO l_hd_payment_tbl(j).PAYMENT_REF_NUMBER
3119: FROM oe_payments
3120: WHERE header_id =l_order_header_id
3121: AND payment_level_code ='ORDER'
3122: AND payment_type_code ='CREDIT_CARD'
3123: AND PAYMENT_COLLECTION_EVENT='INVOICE';