APPS.QP_DENORMALIZED_PRICING_ATTRS dependencies on QP_LIST_HEADERS_B

Line 28: FROM qp_list_headers_b

24: IF p_list_header_id_low IS NULL AND p_list_header_id_high IS NULL THEN
25: BEGIN
26: SELECT min(list_header_id), max(list_header_id)
27: INTO l_list_header_id_low, l_list_header_id_high
28: FROM qp_list_headers_b
29: WHERE list_type_code = 'PML';
30:
31: EXCEPTION
32: WHEN OTHERS THEN

Line 53: FROM qp_list_headers_b

49:
50: --Bulk Collect the Factor List Header Ids into l_list_header_id_tbl
51: SELECT list_header_id
52: BULK COLLECT INTO l_list_header_id_tbl
53: FROM qp_list_headers_b
54: WHERE list_type_code = 'PML'
55: AND list_header_id BETWEEN l_list_header_id_low AND l_list_header_id_high;
56:
57: p_list_header_id_tbl := l_list_header_id_tbl;

Line 111: FROM qp_list_headers_b

107: WHERE a.distinct_row_count = (SELECT min(b.distinct_row_count)
108: FROM qp_pricing_attributes b
109: WHERE b.list_line_id = a.list_line_id)
110: AND a.list_header_id IN (SELECT list_header_id
111: FROM qp_list_headers_b
112: WHERE list_type_code = 'PML'
113: AND list_header_id BETWEEN l_list_header_id_low
114: AND l_list_header_id_high)
115: GROUP BY a.list_line_id;

Line 204: FROM qp_list_headers_b

200: AND aa.comparison_operator_code = a.comparison_operator_code
201: AND aa.list_header_id = a.list_header_id
202: AND aa.pricing_attribute_context IS NOT NULL)
203: WHERE a.list_header_id IN (SELECT list_header_id
204: FROM qp_list_headers_b
205: WHERE list_type_code = 'PML'
206: AND list_header_id BETWEEN p_list_header_id_low
207: AND p_list_header_id_high);
208:

Line 226: FROM qp_list_headers_b

222: IF p_list_header_id_low IS NULL AND p_list_header_id_high IS NULL THEN
223: BEGIN
224: SELECT min(list_header_id), max(list_header_id)
225: INTO l_list_header_id_low, l_list_header_id_high
226: FROM qp_list_headers_b
227: WHERE list_type_code = 'PML';
228: EXCEPTION
229: WHEN OTHERS THEN
230: l_list_header_id_low := 0;

Line 256: FROM qp_pricing_attributes a, qp_list_headers_b b

252:
253: INSERT INTO qp_factor_list_attrs
254: (SELECT DISTINCT a.list_header_id,
255: a.pricing_attribute_context, a.pricing_attribute
256: FROM qp_pricing_attributes a, qp_list_headers_b b
257: WHERE a.list_header_id = b.list_header_id
258: AND b.list_type_code = 'PML'
259: AND b.list_header_id BETWEEN
260: l_list_header_id_low AND l_list_header_id_high);