APPS.QP_UTIL dependencies on QP_LIST_LINES

Line 237: FROM qp_price_formula_lines a, qp_list_lines b

233: WHEN no_data_found THEN
234: BEGIN
235: SELECT 'Y'
236: INTO x_is_used
237: FROM qp_price_formula_lines a, qp_list_lines b
238: WHERE a.pricing_attribute_context = p_context_code
239: AND a.pricing_attribute = p_attribute_code
240: AND a.price_formula_id = b.price_by_formula_id
241: AND rownum < 2;

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

330: WHEN no_data_found THEN
331: BEGIN
332: SELECT 'Y'
333: INTO x_is_used
334: FROM qp_price_formula_lines a, qp_list_lines b, qp_list_headers_b c
335: WHERE a.pricing_attribute_context = p_context_code
336: AND a.pricing_attribute = p_attribute_code
337: AND a.price_formula_id = b.price_by_formula_id
338: AND b.list_header_id = c.list_header_id

Line 4043: , p_list_line_id IN qp_list_lines.list_line_id%type

4039: -- mkarya for bug 2442212, Prevent update of modifier if PTE does not match with Profile value
4040: -- New procedure created
4041: PROCEDURE Check_Source_System_Code
4042: ( p_list_header_id IN qp_list_headers_b.list_header_id%type
4043: , p_list_line_id IN qp_list_lines.list_line_id%type
4044: , x_return_status OUT NOCOPY VARCHAR2
4045: )
4046: is
4047: l_source_system_code qp_list_headers_b.source_system_code%type;

Line 4072: qp_list_lines ll

4068: into l_source_system_code
4069: , l_list_type_code
4070: , l_pte_code
4071: from qp_list_headers_b lh,
4072: qp_list_lines ll
4073: where ll.list_line_id = p_list_line_id
4074: and lh.list_header_id = ll.list_header_id;
4075: end if;
4076: