464: , cv_price_list_id IN NUMBER
465: ) IS
466: SELECT ql.list_price
467: FROM qp_list_lines ql
468: , qp_pricing_attributes atr
469: WHERE ql.list_line_id = atr.list_line_id
470: AND atr.product_attribute_context = 'ITEM'
471: AND atr.product_attribute = 'PRICING_ATTRIBUTE1'
472: AND atr.product_attr_value = TO_CHAR(cv_item_id) --ninarasi fix for bug 12939639