APPS.OE_REASONS_UTIL dependencies on OE_PRICE_ADJUSTMENTS
Line 46: FROM oe_price_adjustments WHERE price_adjustment_id = p_entity_id;
42: SELECT header_id INTO l_header_id
43: FROM oe_order_lines_all WHERE line_id = p_entity_id;
44: ELSIF p_entity_code IN ('HEADER_ADJ','LINE_ADJ') THEN
45: SELECT header_id INTO l_header_id 46: FROM oe_price_adjustments WHERE price_adjustment_id = p_entity_id; 47: ELSIF p_entity_code IN ('HEADER_SCREDIT','LINE_SCREDIT') THEN
48: SELECT header_id INTO l_header_id
49: FROM oe_sales_credits WHERE sales_credit_id = p_entity_id;
50: ELSIF p_entity_code = 'BLANKET_HEADER' THEN