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 1754: FROM qp_price_book_headers_vl

1750: --Publish existing price book
1751: BEGIN
1752: SELECT price_book_header_id
1753: INTO l_publish_price_book_header_id
1754: FROM qp_price_book_headers_vl
1755: WHERE customer_id = l_pb_input_header_rec.customer_attr_value
1756: AND price_book_type_code =
1757: l_pb_input_header_rec.price_book_type_code
1758: AND price_book_name = l_pb_input_header_rec.price_book_name;

Line 1791: FROM qp_price_book_headers_vl

1787:
1788: BEGIN
1789: SELECT price_book_header_id, request_id
1790: INTO l_overwrite_pb_header_id, l_old_request_id
1791: FROM qp_price_book_headers_vl
1792: WHERE price_book_name = l_pb_input_header_rec.price_book_name
1793: AND price_book_type_code =
1794: l_pb_input_header_rec.price_book_type_code
1795: AND customer_id = l_pb_input_header_rec.customer_attr_value;

Line 1877: FROM qp_price_book_headers_vl

1873: IF l_pb_input_header_rec.price_book_type_code = 'F' THEN
1874: BEGIN
1875: SELECT price_book_header_id, request_id
1876: INTO l_corr_delta_pb_header_id, l_old_delta_request_id
1877: FROM qp_price_book_headers_vl
1878: WHERE price_book_name = l_pb_input_header_rec.price_book_name
1879: AND price_book_type_code = 'D'
1880: AND customer_id = l_pb_input_header_rec.customer_attr_value;
1881: EXCEPTION