APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_PRICING_ATTRIBUTES

Line 5202: , qp_pricing_attributes qppa

5198: Cursor get_gsa_list_lines is
5199: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
5200: From
5201: qp_qualifiers qpq
5202: , qp_pricing_attributes qppa
5203: , qp_list_lines qpll
5204: , qp_list_headers_b qplh
5205: , qp_price_req_sources qpprs
5206: where

Line 5631: select product_attr_value into l_item_id from qp_pricing_attributes

5627: l_item_id number;
5628: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5629: l_desc varchar2(200);
5630: BEGIN
5631: select product_attr_value into l_item_id from qp_pricing_attributes
5632: where list_line_id=l_list_line_no;
5633:
5634: oe_debug_pub.add('after fetching the attribute value');
5635:

Line 5695: select product_attr_value into l_item_id from qp_pricing_attributes

5691:
5692: oe_debug_pub.add('out_benefit'||out_benefit||'out_benefit_method'
5693: ||out_benefit_method||'out_benefit_value'||out_benefit_value);
5694:
5695: select product_attr_value into l_item_id from qp_pricing_attributes
5696: where list_line_id=l_list_line_no;
5697:
5698: oe_debug_pub.add('after fetching the attribute value');
5699: