DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_PUB dependencies on QP_LIST_HEADERS_B

Line 160: from qp_list_headers_b

156: IF p_PRICE_LIST_LINE_tbl(1).list_header_id IS NOT NULL AND
157: p_PRICE_LIST_LINE_tbl(1).list_header_id <> FND_API.G_MISS_NUM THEN
158: BEGIN
159: select list_source_code into l_list_source_code
160: from qp_list_headers_b
161: where list_header_id = p_PRICE_LIST_LINE_tbl(1).list_header_id;
162: EXCEPTION
163: WHEN OTHERS THEN
164: oe_debug_pub.add('PRICELIST LINE list_header_id : '||p_PRICE_LIST_LINE_tbl(1).list_header_id);

Line 175: from qp_list_headers_b

171: ELSIF p_PRICE_LIST_LINE_tbl(1).list_line_id IS NOT NULL AND
172: p_PRICE_LIST_LINE_tbl(1).list_line_id <> FND_API.G_MISS_NUM THEN
173: BEGIN
174: select list_source_code into l_list_source_code
175: from qp_list_headers_b
176: where list_header_id = (select list_header_id from qp_list_lines
177: where list_line_id = p_PRICE_LIST_LINE_tbl(1).list_line_id);
178: EXCEPTION
179: WHEN OTHERS THEN