APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_PAYMENTS

Line 3400: FROM oe_payments

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

Line 3442: FROM oe_payments

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

Line 5857: FROM oe_payments

5853: p_x_line_payment_tbl(I).header_id := l_header_id;
5854: p_x_line_payment_tbl(I).line_id := l_line_id;
5855:
5856: SELECT 1 into l_count
5857: FROM oe_payments
5858: WHERE header_id = p_x_header_rec.header_id
5859: AND line_id = l_line_id
5860: AND orig_sys_payment_ref =
5861: p_x_line_payment_tbl(I).orig_sys_payment_ref

Line 5899: FROM oe_payments

5895: p_x_line_payment_tbl(I).header_id := l_header_id;
5896: p_x_line_payment_tbl(I).line_id := l_line_id;
5897: SELECT 1
5898: INTO l_count
5899: FROM oe_payments
5900: WHERE header_id = p_x_header_rec.header_id
5901: AND line_id = l_line_id
5902: AND orig_sys_payment_ref =
5903: p_x_line_payment_tbl(I).orig_sys_payment_ref;