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 4020: , p_list_line_id IN qp_list_lines.list_line_id%type

4016: -- mkarya for bug 2442212, Prevent update of modifier if PTE does not match with Profile value
4017: -- New procedure created
4018: PROCEDURE Check_Source_System_Code
4019: ( p_list_header_id IN qp_list_headers_b.list_header_id%type
4020: , p_list_line_id IN qp_list_lines.list_line_id%type
4021: , x_return_status OUT NOCOPY VARCHAR2
4022: )
4023: is
4024: l_source_system_code qp_list_headers_b.source_system_code%type;

Line 4049: qp_list_lines ll

4045: into l_source_system_code
4046: , l_list_type_code
4047: , l_pte_code
4048: from qp_list_headers_b lh,
4049: qp_list_lines ll
4050: where ll.list_line_id = p_list_line_id
4051: and lh.list_header_id = ll.list_header_id;
4052: end if;
4053: