APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRICE_BOOK_HEADERS_VL

Line 983: FROM qp_price_book_headers_vl

979: --Check if a corresponding full price book exists
980: BEGIN
981: SELECT 1
982: INTO l_count
983: FROM qp_price_book_headers_vl
984: WHERE price_book_name = p_pb_input_header_rec.price_book_name
985: AND price_book_type_code = 'F'
986: AND customer_id = p_pb_input_header_rec.customer_attr_value
987: AND rownum = 1;

Line 1396: FROM qp_price_book_headers_vl

1392: --The price book to be re-published must exist
1393: BEGIN
1394: SELECT 1
1395: INTO l_count
1396: FROM qp_price_book_headers_vl
1397: WHERE price_book_name = p_pb_input_header_rec.price_book_name
1398: AND price_book_type_code = p_pb_input_header_rec.price_book_type_code
1399: AND customer_id = p_pb_input_header_rec.customer_attr_value
1400: AND rownum = 1;

Line 1428: FROM qp_price_book_headers_vl

1424: --Check that Price Book(s) to be generated does(do) not exist
1425: BEGIN
1426: SELECT 1
1427: INTO l_count
1428: FROM qp_price_book_headers_vl
1429: WHERE price_book_name = p_pb_input_header_rec.price_book_name
1430: AND price_book_type_code = p_pb_input_header_rec.price_book_type_code
1431: AND customer_id = p_pb_input_header_rec.customer_attr_value
1432: AND rownum = 1;