DBA Data[Home] [Help]

APPS.OE_LINE_ADJ_ASSOCS_UTIL dependencies on OE_ORDER_LINES_ALL

Line 715: SELECT p.price_adjustment_id INTO l_price_adjustment_id FROM oe_order_lines_all l, oe_price_adjustments p

711: oe_debug_pub.ADD('Getting data',1);
712:
713: BEGIN
714: --Get the price_adjustment_id of the PRG adjustment record
715: SELECT p.price_adjustment_id INTO l_price_adjustment_id FROM oe_order_lines_all l, oe_price_adjustments p
716: WHERE l.line_id = p_to_line_id AND l.service_reference_type_code = 'ORDER' AND p.line_id = l.service_reference_line_id AND p.list_line_id = p_prg_list_line_id;
717:
718: oe_debug_pub.ADD('l_price_adjustment_id '||l_price_adjustment_id,1);
719: