DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on QP_PRICE_FORMULA_LINES

Line 237: FROM qp_price_formula_lines a, qp_list_lines b

233: WHEN no_data_found THEN
234: BEGIN
235: SELECT 'Y'
236: INTO x_is_used
237: FROM qp_price_formula_lines a, qp_list_lines b
238: WHERE a.pricing_attribute_context = p_context_code
239: AND a.pricing_attribute = p_attribute_code
240: AND a.price_formula_id = b.price_by_formula_id
241: AND rownum < 2;

Line 247: FROM qp_price_formula_lines a, qp_currency_details b

243: WHEN no_data_found THEN
244: BEGIN
245: SELECT 'Y'
246: INTO x_is_used
247: FROM qp_price_formula_lines a, qp_currency_details b
248: WHERE a.pricing_attribute_context = p_context_code
249: AND a.pricing_attribute = p_attribute_code
250: AND (a.price_formula_id = b.price_formula_id
251: OR a.price_formula_id = b.markup_formula_id)

Line 334: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c

330: WHEN no_data_found THEN
331: BEGIN
332: SELECT 'Y'
333: INTO x_is_used
334: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
335: WHERE a.pricing_attribute_context = p_context_code
336: AND a.pricing_attribute = p_attribute_code
337: AND a.price_formula_id = b.price_by_formula_id
338: AND b.list_header_id = c.list_header_id

Line 346: FROM qp_price_formula_lines a, qp_currency_details b

342: WHEN no_data_found THEN
343: BEGIN
344: SELECT 'Y'
345: INTO x_is_used
346: FROM qp_price_formula_lines a, qp_currency_details b
347: WHERE a.pricing_attribute_context = p_context_code
348: AND a.pricing_attribute = p_attribute_code
349: AND (a.price_formula_id = b.price_formula_id
350: OR a.price_formula_id = b.markup_formula_id)