APPS.OE_LINE_ADJ_ASSOCS_UTIL dependencies on OE_PRICE_ADJUSTMENTS

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:

Line 727: SELECT p.price_adjustment_id INTO l_rltd_price_adj_id FROM oe_price_adjustments p

723:
724: END;
725:
726: BEGIN
727: SELECT p.price_adjustment_id INTO l_rltd_price_adj_id FROM oe_price_adjustments p
728: WHERE p.line_id =p_to_line_id AND p.list_line_id = p_assoc_list_line_id;
729: oe_debug_pub.ADD('l_rltd_price_adj_id '||l_rltd_price_adj_id,1);
730: EXCEPTION
731: WHEN No_Data_Found THEN