APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 2784: FROM oe_price_adjustments

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

Line 2824: FROM oe_price_adjustments

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

Line 5192: FROM oe_price_adjustments

5188: /* Bug #2108967 -- Passing the correct line_id */
5189: p_x_line_adj_tbl(I).line_id := p_x_line_tbl(p_x_line_adj_tbl(I).line_index).line_id;
5190:
5191: SELECT 1 into l_count
5192: FROM oe_price_adjustments
5193: WHERE header_id = p_x_header_rec.header_id
5194: AND line_id = l_line_id
5195: AND orig_sys_discount_ref =
5196: p_x_line_adj_tbl(I).orig_sys_discount_ref

Line 5238: FROM oe_price_adjustments

5234: p_x_line_adj_tbl(I).header_id := l_header_id;
5235: p_x_line_adj_tbl(I).line_id := p_x_line_tbl(p_x_line_adj_tbl(I).line_index).line_id;
5236: SELECT price_adjustment_id
5237: INTO l_price_adjustment_id
5238: FROM oe_price_adjustments
5239: WHERE header_id = l_header_id
5240: AND line_id = p_x_line_adj_tbl(I).line_id
5241: AND orig_sys_discount_ref =
5242: p_x_line_adj_tbl(I).orig_sys_discount_ref;