306: NVL(-spl.rounding_factor,2))
307: into arg_price
308: from oe_price_list_lines sopl,
309: mtl_system_items msi,
310: oe_price_lists spl
311: where spl.price_list_id = FND_PROFILE.Value_Specific('MRP_BIS_PRICE_LIST')
312: and sopl.price_list_id = spl.price_list_id
313: and sopl.inventory_item_id = arg_item_id
314: and msi.inventory_item_id = arg_item_id
340: select round(list_price,NVL(spl.rounding_factor,2))
341: into arg_price
342: from oe_price_list_lines sopl,
343: mtl_system_items msi,
344: oe_price_lists spl
345: where spl.price_list_id = arg_price_list_id
346: and sopl.price_list_id = spl.price_list_id
347: and sopl.inventory_item_id = arg_item_id
348: and msi.inventory_item_id = arg_item_id