APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_PRICING_ATTRIBUTES

Line 5177: , qp_pricing_attributes qppa

5173: Cursor get_gsa_list_lines is
5174: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
5175: From
5176: qp_qualifiers qpq
5177: , qp_pricing_attributes qppa
5178: , qp_list_lines qpll
5179: , qp_list_headers_b qplh
5180: , qp_price_req_sources qpprs
5181: where

Line 5606: select product_attr_value into l_item_id from qp_pricing_attributes

5602: l_item_id number;
5603: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5604: l_desc varchar2(200);
5605: BEGIN
5606: select product_attr_value into l_item_id from qp_pricing_attributes
5607: where list_line_id=l_list_line_no;
5608:
5609: oe_debug_pub.add('after fetching the attribute value');
5610:

Line 5670: select product_attr_value into l_item_id from qp_pricing_attributes

5666:
5667: oe_debug_pub.add('out_benefit'||out_benefit||'out_benefit_method'
5668: ||out_benefit_method||'out_benefit_value'||out_benefit_value);
5669:
5670: select product_attr_value into l_item_id from qp_pricing_attributes
5671: where list_line_id=l_list_line_no;
5672:
5673: oe_debug_pub.add('after fetching the attribute value');
5674: