DBA Data[Home] [Help]

APPS.OE_REASONS_UTIL dependencies on OE_ORDER_LINES_ALL

Line 43: FROM oe_order_lines_all WHERE line_id = p_entity_id;

39: IF p_entity_code = 'HEADER' THEN
40: l_header_id := p_entity_id;
41: ELSIF p_entity_code = 'LINE' THEN
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