APPS.QP_ATTR_MAPPING_PUB dependencies on QP_PRICE_FORMULA_LINES

Line 746: FROM QP_PRICE_FORMULA_LINES A

742: BEGIN
743: --Bug#5007983 START
744: SELECT 'Y'
745: INTO v_is_used
746: FROM QP_PRICE_FORMULA_LINES A
747: WHERE A.PRICING_ATTRIBUTE_CONTEXT = l_context_name
748: AND A.PRICING_ATTRIBUTE = l_attribute_name
749: AND EXISTS
750: (SELECT /*+ no_unest */ 'x'

Line 761: FROM qp_price_formula_lines a

757:
758: BEGIN
759: SELECT 'Y'
760: INTO v_is_used
761: FROM qp_price_formula_lines a
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'

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

826: --Changes made by rnayani Bug # 4960639 START
827: /**
828: SELECT 'Y'
829: INTO v_is_used
830: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
831: WHERE a.pricing_attribute_context = l_context_name
832: AND a.pricing_attribute = l_attribute_name
833: AND a.price_formula_id = b.price_by_formula_id
834: AND b.list_header_id = c.list_header_id

Line 840: FROM qp_price_formula_lines a

836: AND rownum < 2;
837: **/
838: SELECT 'Y'
839: INTO v_is_used
840: FROM qp_price_formula_lines a
841: WHERE a.pricing_attribute_context = l_context_name AND
842: a.pricing_attribute = l_attribute_name AND
843: EXISTS (SELECT 'x'
844: FROM qp_list_lines b, qp_list_headers_b c

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

1330:
1331: --Bug#5007983 START
1332: SELECT 'Y'
1333: INTO v_is_used
1334: FROM qp_price_formula_lines a
1335: WHERE a.pricing_attribute_context = l_context_name
1336: AND a.pricing_attribute = l_attribute_name
1337: AND EXISTS
1338: (SELECT /*+ no_unest */ 'x'

Line 1353: FROM qp_price_formula_lines a

1349:
1350: --Bug#5007983 START
1351: SELECT 'Y'
1352: INTO v_is_used
1353: FROM qp_price_formula_lines a
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'

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

1450: --Changes made by rnayani Bug # 4960639 START
1451: /**
1452: SELECT 'Y'
1453: INTO v_is_used
1454: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
1455: WHERE a.pricing_attribute_context = l_context_name
1456: AND a.pricing_attribute = l_attribute_name
1457: AND a.price_formula_id = b.price_by_formula_id
1458: AND b.list_header_id = c.list_header_id

Line 1464: FROM qp_price_formula_lines a

1460: AND rownum < 2;
1461: **/
1462: SELECT 'Y'
1463: INTO v_is_used
1464: FROM qp_price_formula_lines a
1465: WHERE a.pricing_attribute_context = l_context_name AND
1466: a.pricing_attribute = l_attribute_name AND
1467: EXISTS (SELECT /*+ no_unest */ 'x'
1468: FROM qp_list_lines b, qp_list_headers_b c

Line 1483: FROM qp_price_formula_lines a

1479:
1480: --Bug#5007983 START
1481: SELECT 'Y'
1482: INTO v_is_used
1483: FROM qp_price_formula_lines a
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'

Line 3761: FROM qp_price_formula_lines

3757: BEGIN
3758:
3759: SELECT 'Y'
3760: INTO x_out
3761: FROM qp_price_formula_lines
3762: WHERE pricing_attribute_context = p_attribute_context
3763: AND pricing_attribute = p_attribute_code
3764: AND ROWNUM < 2;
3765: