The following lines contain the word 'select', 'insert', 'update' or 'delete':
select sum(nvl(cpal.quantity_packed,0))
from csp_packlist_lines cpal
where cpal.picklist_line_id = p_picklist_line_id;
select sum(nvl(cpasl.quantity,0))
from csp_packlist_serial_lots cpasl,
csp_packlist_lines cpal
where cpal.picklist_line_id = p_picklist_line_id
and cpasl.packlist_line_id = cpal.packlist_line_id
and decode(p_serial_number,null,'1',cpasl.serial_number) = decode(p_serial_number,null,'1',p_serial_number)
and decode(p_lot_number,null,'1',cpasl.lot_number) = decode(p_lot_number,null,'1',p_lot_number);