APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRICE_BOOK_HEADERS_ALL_B

Line 1461: FROM qp_price_book_headers_all_b b, qp_price_book_headers_tl t

1457: --org outside the accessible orgs
1458: BEGIN
1459: SELECT 1
1460: INTO l_count2
1461: FROM qp_price_book_headers_all_b b, qp_price_book_headers_tl t
1462: WHERE b.price_book_header_id = t.price_book_header_id
1463: AND t.language = userenv('LANG')
1464: AND b.price_book_type_code = p_pb_input_header_rec.price_book_type_code
1465: AND b.customer_id = p_pb_input_header_rec.customer_attr_value

Line 2382: FROM qp_price_book_headers_all_b b, qp_price_book_headers_tl t

2378: --Check if the price book already exists for an org that is not accessible
2379: BEGIN
2380: SELECT 1
2381: INTO l_count
2382: FROM qp_price_book_headers_all_b b, qp_price_book_headers_tl t
2383: WHERE b.price_book_header_id = t.price_book_header_id
2384: AND t.language = userenv('LANG')
2385: AND b.price_book_type_code = p_pb_input_header_rec.price_book_type_code
2386: AND b.customer_id = p_pb_input_header_rec.customer_attr_value

Line 2398: INSERT INTO qp_price_book_headers_all_b (

2394: IF l_count > 0 THEN
2395: RAISE FND_API.G_EXC_ERROR;
2396: END IF;
2397:
2398: INSERT INTO qp_price_book_headers_all_b (
2399: price_book_header_id,
2400: price_book_type_code,
2401: currency_code,
2402: effective_date,

Line 2421: (qp_price_book_headers_all_b_s.nextval,

2417: last_updated_by,
2418: last_update_login
2419: )
2420: VALUES
2421: (qp_price_book_headers_all_b_s.nextval,
2422: p_pb_input_header_rec.price_book_type_code,
2423: p_pb_input_header_rec.currency_code,
2424: p_pb_input_header_rec.effective_date,
2425: p_pb_input_header_rec.org_id,