APPS.QP_ATTR_MAPPING_PUB dependencies on QP_CURRENCY_DETAILS

Line 833: FROM qp_currency_details b

829: WHERE a.pricing_attribute_context = l_context_name
830: AND a.pricing_attribute = l_attribute_name
831: AND EXISTS
832: (SELECT /*+ no_unest */ 'x'
833: FROM qp_currency_details b
834: WHERE a.price_formula_id = b.price_formula_id
835: OR a.price_formula_id = b.markup_formula_id
836: )
837: AND ROWNUM < 2;

Line 926: FROM qp_price_formula_lines a, qp_currency_details b

922:
923: --Bug#5007983 START
924: SELECT 'Y'
925: INTO v_is_used
926: FROM qp_price_formula_lines a, qp_currency_details b
927: WHERE a.pricing_attribute_context = l_context_name
928: AND a.pricing_attribute = l_attribute_name
929: AND EXISTS
930: (SELECT /*+ no_unest */ 'x'

Line 931: FROM qp_currency_details b

927: WHERE a.pricing_attribute_context = l_context_name
928: AND a.pricing_attribute = l_attribute_name
929: AND EXISTS
930: (SELECT /*+ no_unest */ 'x'
931: FROM qp_currency_details b
932: WHERE a.price_formula_id = b.price_formula_id
933: OR a.price_formula_id = b.markup_formula_id
934: )
935: AND ROWNUM < 2;

Line 1425: FROM qp_currency_details b

1421: WHERE a.pricing_attribute_context = l_context_name
1422: AND a.pricing_attribute = l_attribute_name
1423: AND EXISTS
1424: (SELECT /*+ no_unest */ 'x'
1425: FROM qp_currency_details b
1426: WHERE a.price_formula_id = b.price_formula_id
1427: OR a.price_formula_id = b.markup_formula_id
1428: )
1429: AND ROWNUM < 2;

Line 1438: FROM qp_currency_details

1434: --bug 7494395
1435: BEGIN
1436: SELECT 'Y'
1437: INTO v_is_used
1438: FROM qp_currency_details
1439: WHERE curr_attribute_type = l_context_type
1440: AND curr_attribute_context = l_context_name
1441: AND curr_attribute = l_attribute_name
1442: AND rownum < 2;

Line 1555: FROM qp_currency_details b

1551: WHERE a.pricing_attribute_context = l_context_name
1552: AND a.pricing_attribute = l_attribute_name
1553: AND EXISTS
1554: (SELECT /*+ no_unest */ 'x'
1555: FROM qp_currency_details b
1556: WHERE a.price_formula_id = b.price_formula_id
1557: OR a.price_formula_id = b.markup_formula_id
1558: )
1559: AND ROWNUM < 2;

Line 1568: FROM qp_currency_details

1564: --bug 7494395
1565: BEGIN
1566: SELECT 'Y'
1567: INTO v_is_used
1568: FROM qp_currency_details
1569: WHERE curr_attribute_type = l_context_type
1570: AND curr_attribute_context = l_context_name
1571: AND curr_attribute = l_attribute_name
1572: AND rownum < 2;