APPS.OE_UPGRADE_MISC dependencies on OE_PRICE_ADJUSTMENTS

Line 153: FROM OE_PRICE_ADJUSTMENTS

149: x_return_status := 'S';
150: l_count := 0;
151: SELECT count(*)
152: INTO l_count
153: FROM OE_PRICE_ADJUSTMENTS
154: WHERE header_id = p_header_id
155: AND line_id = p_line_id
156: AND cost_id = p_freight_charge_id;
157:

Line 203: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;

199: END;
200:
201:
202: -- Get the price_adjustment_id
203: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
204:
205: INSERT INTO OE_PRICE_ADJUSTMENTS
206: (
207: PRICE_ADJUSTMENT_ID

Line 205: INSERT INTO OE_PRICE_ADJUSTMENTS

201:
202: -- Get the price_adjustment_id
203: SELECT OE_PRICE_ADJUSTMENTS_S.nextval INTO l_price_adjustment_id FROM DUAL;
204:
205: INSERT INTO OE_PRICE_ADJUSTMENTS
206: (
207: PRICE_ADJUSTMENT_ID
208: , CREATION_DATE
209: , CREATED_BY