APPS.QP_PRICE_BOOK_PUB dependencies on QP_PB_INPUT_HEADERS_VL

Line 66: FROM qp_pb_input_headers_vl

62:
63: BEGIN
64: SELECT pb_input_header_id
65: INTO l_pb_input_header_id
66: FROM qp_pb_input_headers_vl
67: WHERE price_book_name = l_pb_input_header_rec.price_book_name
68: AND customer_attr_value = l_pb_input_header_rec.customer_attr_value
69: AND customer_context = 'CUSTOMER'
70: AND customer_attribute = 'QUALIFIER_ATTRIBUTE2'

Line 135: FROM qp_pb_input_headers_vl

131: --Fetch pb_input_header_id of corresponding full price book
132: BEGIN
133: SELECT pb_input_header_id
134: INTO l_full_pb_input_header_id
135: FROM qp_pb_input_headers_vl
136: WHERE price_book_name = l_pb_input_header_rec.price_book_name
137: AND customer_attr_value = l_pb_input_header_rec.customer_attr_value
138: AND customer_context = 'CUSTOMER'
139: AND customer_attribute = 'QUALIFIER_ATTRIBUTE2'

Line 191: FROM qp_pb_input_headers_vl

187: l_pb_input_header_rec.pl_agr_bsa_id,
188: l_pb_input_header_rec.pricing_perspective_code,
189: l_pb_input_header_rec.request_type_code,
190: l_pb_input_header_rec.pl_agr_bsa_name
191: FROM qp_pb_input_headers_vl
192: WHERE pb_input_header_id = l_full_pb_input_header_id;
193: EXCEPTION
194: WHEN OTHERS THEN
195: x_return_status := 'E';