APPS.QP_PRICE_BOOK_PVT dependencies on QP_PRICE_BOOK_HEADERS_VL

Line 82: FROM qp_price_book_headers_vl

78: --Get the price_book_header_id of the corresponding full price book
79: BEGIN
80: SELECT price_book_header_id
81: INTO l_full_price_book_header_id
82: FROM qp_price_book_headers_vl
83: WHERE price_book_type_code = 'F'
84: AND price_book_name = p_delta_price_book_name
85: AND customer_id = p_delta_price_book_customer_id;
86: EXCEPTION

Line 1773: FROM qp_price_book_headers_vl

1769: --Publish existing price book
1770: BEGIN
1771: SELECT price_book_header_id
1772: INTO l_publish_price_book_header_id
1773: FROM qp_price_book_headers_vl
1774: WHERE customer_id = l_pb_input_header_rec.customer_attr_value
1775: AND price_book_type_code =
1776: l_pb_input_header_rec.price_book_type_code
1777: AND price_book_name = l_pb_input_header_rec.price_book_name;

Line 1810: FROM qp_price_book_headers_vl

1806:
1807: BEGIN
1808: SELECT price_book_header_id, request_id
1809: INTO l_overwrite_pb_header_id, l_old_request_id
1810: FROM qp_price_book_headers_vl
1811: WHERE price_book_name = l_pb_input_header_rec.price_book_name
1812: AND price_book_type_code =
1813: l_pb_input_header_rec.price_book_type_code
1814: AND customer_id = l_pb_input_header_rec.customer_attr_value;

Line 1896: FROM qp_price_book_headers_vl

1892: IF l_pb_input_header_rec.price_book_type_code = 'F' THEN
1893: BEGIN
1894: SELECT price_book_header_id, request_id
1895: INTO l_corr_delta_pb_header_id, l_old_delta_request_id
1896: FROM qp_price_book_headers_vl
1897: WHERE price_book_name = l_pb_input_header_rec.price_book_name
1898: AND price_book_type_code = 'D'
1899: AND customer_id = l_pb_input_header_rec.customer_attr_value;
1900: EXCEPTION