DBA Data[Home] [Help]

APPS.QP_VALIDATE_PRICE_LIST_LINE dependencies on QP_PRICE_FORMULA_LINES

Line 208: from qp_price_formula_lines

204: into l_dummy_1
205: from qp_price_formulas_b
206: where price_formula_id = p_PRICE_LIST_LINE_rec.generate_using_formula_id
207: and not exists (select price_formula_line_type_code
208: from qp_price_formula_lines
209: where price_formula_id = p_PRICE_LIST_LINE_rec.generate_using_formula_id
210: and price_formula_line_type_code = 'MV' );
211: EXCEPTION
212: WHEN NO_DATA_FOUND THEN

Line 232: from qp_price_formula_lines

228: into l_dummy_1
229: from qp_price_formulas_b
230: where price_formula_id = p_PRICE_LIST_LINE_rec.price_by_formula_id
231: and not exists (select price_formula_line_type_code
232: from qp_price_formula_lines
233: where price_formula_id = p_PRICE_LIST_LINE_rec.price_by_formula_id
234: and price_formula_line_type_code = 'MV' );
235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN