APPS.OE_OE_FORM_LINE_ADJ dependencies on OE_PRICE_ADJUSTMENTS

Line 3392: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL

3388: IF l_line_adj_tbl(1).automatic_flag IS NULL THEN
3389: l_line_adj_tbl(1).automatic_flag:='N';
3390: END IF;
3391:
3392: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3393: INTO l_line_adj_tbl(1).price_adjustment_id
3394: FROM Dual;
3395:
3396:

Line 3513: From oe_price_adjustments

3509: p_create_adj_no_validate In Boolean Default FALSE) Is
3510:
3511: Cursor adjustment_cur(p_list_line_id Number ,p_line_id Number) Is
3512: Select price_adjustment_id,operand,change_reason_code
3513: From oe_price_adjustments
3514: Where line_id = p_line_id
3515: and list_line_id = p_list_line_id;
3516:
3517: i PLS_INTEGER;