APPS.QP_ID_TO_VALUE dependencies on QP_LOOKUPS

Line 435: FROM QP_LOOKUPS

431: IF p_list_type_code IS NOT NULL THEN
432:
433: SELECT MEANING
434: INTO l_list_type
435: FROM QP_LOOKUPS
436: WHERE LOOKUP_CODE = p_list_type_code
437: AND LOOKUP_TYPE = 'LIST_TYPE_CODE';
438:
439: END IF;

Line 880: from qp_lookups

876: IF p_list_line_type_code IS NOT NULL THEN
877:
878: select meaning
879: into l_list_line_type
880: from qp_lookups
881: where lookup_code = p_list_line_type_code
882: and lookup_type = 'LIST_LINE_TYPE_CODE';
883:
884:

Line 1181: from qp_lookups

1177: IF p_price_break_type_code IS NOT NULL THEN
1178:
1179: select meaning
1180: into l_price_break_type
1181: from qp_lookups
1182: where lookup_code = p_price_break_type_code
1183: and lookup_type = 'PRICE_BREAK_TYPE_CODE';
1184:
1185: -- SELECT PRICE_BREAK_TYPE

Line 2322: FROM QP_LOOKUPS

2318: IF p_formula_line_type_code IS NOT NULL THEN
2319:
2320: SELECT MEANING
2321: INTO l_price_formula_line_type
2322: FROM QP_LOOKUPS
2323: WHERE LOOKUP_CODE = p_formula_line_type_code
2324: AND LOOKUP_TYPE = 'PRICE_FORMULA_LINE_TYPE_CODE';
2325:
2326: END IF;

Line 2419: from qp_lookups

2415: IF p_arithmetic_operator IS NOT NULL THEN
2416:
2417: select meaning
2418: into l_arithmetic_operator
2419: from qp_lookups
2420: where lookup_code = p_arithmetic_operator
2421: and lookup_type = 'ARITHMETIC_OPERATOR';
2422:
2423: END IF;

Line 2620: FROM QP_LOOKUPS

2616: IF p_freight_terms_code IS NOT NULL THEN
2617:
2618: SELECT MEANING
2619: INTO l_freight_terms
2620: FROM QP_LOOKUPS
2621: WHERE LOOKUP_CODE = p_freight_terms_code
2622: AND LOOKUP_TYPE = 'FREIGHT_TERMS';
2623:
2624: END IF;

Line 3323: FROM qp_lookups

3319: IF p_agreement_source_code IS NOT NULL THEN
3320:
3321: SELECT meaning
3322: INTO l_agreement_source
3323: FROM qp_lookups
3324: WHERE lookup_code = p_agreement_source_code
3325: AND lookup_type = 'AGREEMENT_SOURCE_CODE';
3326:
3327: END IF;