APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 2781: FROM oe_price_adjustments

2777: p_x_header_adj_tbl(I).header_id := l_header_id;
2778: Begin
2779:
2780: SELECT 1 into l_count
2781: FROM oe_price_adjustments
2782: WHERE header_id = p_x_header_rec.header_id
2783: AND line_id IS NULL
2784: AND orig_sys_discount_ref =
2785: p_x_header_adj_tbl(I).orig_sys_discount_ref

Line 2821: FROM oe_price_adjustments

2817: oe_debug_pub.add( 'DISCOUNT REF: '||P_X_HEADER_ADJ_TBL ( I ) .ORIG_SYS_DISCOUNT_REF ) ;
2818: END IF;
2819: SELECT price_adjustment_id
2820: INTO l_price_adjustment_id
2821: FROM oe_price_adjustments
2822: WHERE header_id = p_x_header_rec.header_id
2823: AND line_id IS NULL
2824: AND orig_sys_discount_ref =
2825: p_x_header_adj_tbl(I).orig_sys_discount_ref;

Line 5125: FROM oe_price_adjustments

5121: /* Bug #2108967 -- Passing the correct line_id */
5122: p_x_line_adj_tbl(I).line_id := p_x_line_tbl(p_x_line_adj_tbl(I).line_index).line_id;
5123:
5124: SELECT 1 into l_count
5125: FROM oe_price_adjustments
5126: WHERE header_id = p_x_header_rec.header_id
5127: AND line_id = l_line_id
5128: AND orig_sys_discount_ref =
5129: p_x_line_adj_tbl(I).orig_sys_discount_ref

Line 5171: FROM oe_price_adjustments

5167: p_x_line_adj_tbl(I).header_id := l_header_id;
5168: p_x_line_adj_tbl(I).line_id := p_x_line_tbl(p_x_line_adj_tbl(I).line_index).line_id;
5169: SELECT price_adjustment_id
5170: INTO l_price_adjustment_id
5171: FROM oe_price_adjustments
5172: WHERE header_id = l_header_id
5173: AND line_id = p_x_line_adj_tbl(I).line_id
5174: AND orig_sys_discount_ref =
5175: p_x_line_adj_tbl(I).orig_sys_discount_ref;