APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_PAYMENTS

Line 3397: FROM oe_payments

3393: oe_debug_pub.add( 'NEW PAYMENT FOR THE EXISITNG HEARDER_ID:' || TO_CHAR ( P_X_HEADER_payment_TBL ( I ) .HEADER_ID ) ) ;
3394: END IF;
3395:
3396: SELECT 1 into l_count
3397: FROM oe_payments
3398: WHERE header_id = p_x_header_rec.header_id
3399: AND line_id IS NULL
3400: AND orig_sys_payment_ref =
3401: p_x_header_payment_tbl(I).orig_sys_payment_ref

Line 3439: FROM oe_payments

3435: oe_debug_pub.add( 'payment REF: '||P_X_HEADER_payment_TBL ( I ) .ORIG_SYS_PAYMENT_REF ) ;
3436: END IF;
3437: SELECT header_id
3438: INTO l_header_id
3439: FROM oe_payments
3440: WHERE header_id = l_header_id
3441: AND line_id IS NULL
3442: AND orig_sys_payment_ref =
3443: p_x_header_payment_tbl(I).orig_sys_payment_ref;

Line 5790: FROM oe_payments

5786: p_x_line_payment_tbl(I).header_id := l_header_id;
5787: p_x_line_payment_tbl(I).line_id := l_line_id;
5788:
5789: SELECT 1 into l_count
5790: FROM oe_payments
5791: WHERE header_id = p_x_header_rec.header_id
5792: AND line_id = l_line_id
5793: AND orig_sys_payment_ref =
5794: p_x_line_payment_tbl(I).orig_sys_payment_ref

Line 5832: FROM oe_payments

5828: p_x_line_payment_tbl(I).header_id := l_header_id;
5829: p_x_line_payment_tbl(I).line_id := l_line_id;
5830: SELECT 1
5831: INTO l_count
5832: FROM oe_payments
5833: WHERE header_id = p_x_header_rec.header_id
5834: AND line_id = l_line_id
5835: AND orig_sys_payment_ref =
5836: p_x_line_payment_tbl(I).orig_sys_payment_ref;