APPS.OE_OE_FORM_LINE_ADJ dependencies on OE_PRICE_ADJUSTMENTS

Line 3409: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL

3405: IF l_line_adj_tbl(1).automatic_flag IS NULL THEN
3406: l_line_adj_tbl(1).automatic_flag:='N';
3407: END IF;
3408:
3409: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3410: INTO l_line_adj_tbl(1).price_adjustment_id
3411: FROM Dual;
3412:
3413:

Line 3543: From oe_price_adjustments

3539: p_create_adj_no_validate In Boolean Default FALSE) Is
3540:
3541: Cursor adjustment_cur(p_list_line_id Number ,p_line_id Number) Is
3542: Select price_adjustment_id,operand,change_reason_code
3543: From oe_price_adjustments
3544: Where line_id = p_line_id
3545: and list_line_id = p_list_line_id;
3546:
3547: i PLS_INTEGER;