The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*)
from op_fobc_mst
where fob_code = p_original_code;
select count(*)
from op_term_mst
where terms_code = p_original_code;
select count(*)
from op_frgt_mth
where frtbill_mthd = p_original_code;
select count(*)
from op_ship_mst
where shipper_code = p_original_code;
select count (*)
from gl_rate_typ
where rate_type_code = p_original_code;
procedure insert_code (p_original_code varchar2);
insert_code(p_original_code);
insert_code(p_original_code);
procedure insert_code(p_original_code varchar2) is
l_table_index binary_integer;
end insert_code;
function delete_session_codes_tab
return number is
begin
g_session_code_tab.delete;
end delete_session_codes_tab;
g_session_code_tab.delete(l_table_index);