APPS.QP_ATTR_MAPPING_PUB dependencies on QP_CURRENCY_DETAILS

Line 766: FROM qp_currency_details b

762: WHERE a.pricing_attribute_context = l_context_name
763: AND a.pricing_attribute = l_attribute_name
764: AND EXISTS
765: (SELECT /*+ no_unest */ 'x'
766: FROM qp_currency_details b
767: WHERE a.price_formula_id = b.price_formula_id
768: OR a.price_formula_id = b.markup_formula_id
769: )
770: AND ROWNUM < 2;

Line 859: FROM qp_price_formula_lines a, qp_currency_details b

855:
856: --Bug#5007983 START
857: SELECT 'Y'
858: INTO v_is_used
859: FROM qp_price_formula_lines a, qp_currency_details b
860: WHERE a.pricing_attribute_context = l_context_name
861: AND a.pricing_attribute = l_attribute_name
862: AND EXISTS
863: (SELECT /*+ no_unest */ 'x'

Line 864: FROM qp_currency_details b

860: WHERE a.pricing_attribute_context = l_context_name
861: AND a.pricing_attribute = l_attribute_name
862: AND EXISTS
863: (SELECT /*+ no_unest */ 'x'
864: FROM qp_currency_details b
865: WHERE a.price_formula_id = b.price_formula_id
866: OR a.price_formula_id = b.markup_formula_id
867: )
868: AND ROWNUM < 2;

Line 1358: FROM qp_currency_details b

1354: WHERE a.pricing_attribute_context = l_context_name
1355: AND a.pricing_attribute = l_attribute_name
1356: AND EXISTS
1357: (SELECT /*+ no_unest */ 'x'
1358: FROM qp_currency_details b
1359: WHERE a.price_formula_id = b.price_formula_id
1360: OR a.price_formula_id = b.markup_formula_id
1361: )
1362: AND ROWNUM < 2;

Line 1371: FROM qp_currency_details

1367: --bug 7494395
1368: BEGIN
1369: SELECT 'Y'
1370: INTO v_is_used
1371: FROM qp_currency_details
1372: WHERE curr_attribute_type = l_context_type
1373: AND curr_attribute_context = l_context_name
1374: AND curr_attribute = l_attribute_name
1375: AND rownum < 2;

Line 1488: FROM qp_currency_details b

1484: WHERE a.pricing_attribute_context = l_context_name
1485: AND a.pricing_attribute = l_attribute_name
1486: AND EXISTS
1487: (SELECT /*+ no_unest */ 'x'
1488: FROM qp_currency_details b
1489: WHERE a.price_formula_id = b.price_formula_id
1490: OR a.price_formula_id = b.markup_formula_id
1491: )
1492: AND ROWNUM < 2;

Line 1501: FROM qp_currency_details

1497: --bug 7494395
1498: BEGIN
1499: SELECT 'Y'
1500: INTO v_is_used
1501: FROM qp_currency_details
1502: WHERE curr_attribute_type = l_context_type
1503: AND curr_attribute_context = l_context_name
1504: AND curr_attribute = l_attribute_name
1505: AND rownum < 2;