APPS.OE_ORDER_PRICE_PVT dependencies on OE_ORDER_LINES_ALL

Line 2035: select line_id from oe_order_lines_all

2031: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
2032: line_Tbl_Index pls_integer;
2033:
2034: CURSOR service_lines is
2035: select line_id from oe_order_lines_all
2036: where
2037: service_reference_line_id=p_line_Id and
2038: service_reference_type_code='ORDER'and
2039: header_id=p_header_id and

Line 3396: FROM oe_order_lines_all

3392: BEGIN
3393:
3394: SELECT line_id
3395: INTO l_dummy
3396: FROM oe_order_lines_all
3397: WHERE ordered_quantity <> 0
3398: AND open_flag <> 'N'
3399: AND line_id in (select line_id
3400: from qp_preq_lines_tmp lines

Line 3435: UPDATE OE_ORDER_LINES_all l

3431:
3432: IF l_debug_level > 0 THEN
3433: oe_debug_pub.add( ' BEFORE UPDATING ORDER LINES' , 3 ) ;
3434: END IF;
3435: UPDATE OE_ORDER_LINES_all l
3436: SET (UNIT_SELLING_PRICE
3437: , UNIT_LIST_PRICE
3438: ,UNIT_SELLING_PRICE_PER_PQTY
3439: ,UNIT_LIST_PRICE_PER_PQTY