The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ato_line_id, ordered_quantity
into config_ato_line_id, config_ordered_qty
from oe_order_lines_all
where line_id = p_config_line_id;
select nvl( sum(l.UNIT_SELLING_PRICE * nvl(ORDERED_QUANTITY,0)) / config_ordered_qty , 0),
nvl((sum(l.UNIT_SELLING_PRICE * nvl(ORDERED_QUANTITY,0)) / config_ordered_qty) * p_quantity, 0),
max(h.TRANSACTIONAL_CURR_CODE)
into x_unit_selling_price,
x_qty_selling_price,
x_currency_code
from oe_order_lines_all l,
oe_order_headers_all h
where l.ato_line_id = decode(p_config_line_id, null, p_model_line_id, config_ato_line_id)
and l.header_id = h.header_id;