The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_tab_ele_ids.delete;
g_add_cont_ele_ids.delete;
select decode(sign(g_add_cont_value(p_assignment_id)),-1,1,0)
from dual;
select sum(dtl.val_10) total_value
from ben_ext_rslt_dtl dtl
--,ben_ext_rcd rcd
where dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
and dtl.ext_rcd_id = p_ext_rcd_id;
select decode(sign(g_total_add_cont),-1,1,0)
from dual;