APPS.QP_ATTR_MAPPING_PUB dependencies on QP_PRICE_FORMULA_LINES

Line 813: FROM QP_PRICE_FORMULA_LINES A

809: BEGIN
810: --Bug#5007983 START
811: SELECT 'Y'
812: INTO v_is_used
813: FROM QP_PRICE_FORMULA_LINES A
814: WHERE A.PRICING_ATTRIBUTE_CONTEXT = l_context_name
815: AND A.PRICING_ATTRIBUTE = l_attribute_name
816: AND EXISTS
817: (SELECT /*+ no_unest */ 'x'

Line 828: FROM qp_price_formula_lines a

824:
825: BEGIN
826: SELECT 'Y'
827: INTO v_is_used
828: FROM qp_price_formula_lines a
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'

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

893: --Changes made by rnayani Bug # 4960639 START
894: /**
895: SELECT 'Y'
896: INTO v_is_used
897: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
898: WHERE a.pricing_attribute_context = l_context_name
899: AND a.pricing_attribute = l_attribute_name
900: AND a.price_formula_id = b.price_by_formula_id
901: AND b.list_header_id = c.list_header_id

Line 907: FROM qp_price_formula_lines a

903: AND rownum < 2;
904: **/
905: SELECT 'Y'
906: INTO v_is_used
907: FROM qp_price_formula_lines a
908: WHERE a.pricing_attribute_context = l_context_name AND
909: a.pricing_attribute = l_attribute_name AND
910: EXISTS (SELECT 'x'
911: FROM qp_list_lines b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769

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 1401: FROM qp_price_formula_lines a

1397:
1398: --Bug#5007983 START
1399: SELECT 'Y'
1400: INTO v_is_used
1401: FROM qp_price_formula_lines a
1402: WHERE a.pricing_attribute_context = l_context_name
1403: AND a.pricing_attribute = l_attribute_name
1404: AND EXISTS
1405: (SELECT /*+ no_unest */ 'x'

Line 1420: FROM qp_price_formula_lines a

1416:
1417: --Bug#5007983 START
1418: SELECT 'Y'
1419: INTO v_is_used
1420: FROM qp_price_formula_lines a
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'

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

1517: --Changes made by rnayani Bug # 4960639 START
1518: /**
1519: SELECT 'Y'
1520: INTO v_is_used
1521: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
1522: WHERE a.pricing_attribute_context = l_context_name
1523: AND a.pricing_attribute = l_attribute_name
1524: AND a.price_formula_id = b.price_by_formula_id
1525: AND b.list_header_id = c.list_header_id

Line 1531: FROM qp_price_formula_lines a

1527: AND rownum < 2;
1528: **/
1529: SELECT 'Y'
1530: INTO v_is_used
1531: FROM qp_price_formula_lines a
1532: WHERE a.pricing_attribute_context = l_context_name AND
1533: a.pricing_attribute = l_attribute_name AND
1534: EXISTS (SELECT /*+ no_unest */ 'x'
1535: FROM qp_list_lines b, qp_list_headers_all c -- qp_list_headers_b c --bug 14065769

Line 1550: FROM qp_price_formula_lines a

1546:
1547: --Bug#5007983 START
1548: SELECT 'Y'
1549: INTO v_is_used
1550: FROM qp_price_formula_lines a
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'

Line 4019: FROM qp_price_formula_lines

4015: BEGIN
4016:
4017: SELECT 'Y'
4018: INTO x_out
4019: FROM qp_price_formula_lines
4020: WHERE pricing_attribute_context = p_attribute_context
4021: AND pricing_attribute = p_attribute_code
4022: AND ROWNUM < 2;
4023: