The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ff.formula_id,
ff.formula_name,
ff.business_group_id,
ff.effective_start_date,
ff.effective_end_date
from ff_formulas_f ff
,ff_compiled_info_f ffci
where ff.formula_id = ffci.formula_id
and ff.effective_start_date = ffci.effective_start_date
and ff.effective_end_date = ffci.effective_end_date
and ff.formula_name = p_formula_name;
select ff.formula_id,
ff.formula_name,
ff.business_group_id,
ff.effective_start_date,
ff.effective_end_date
from ff_formulas_f ff
,ff_compiled_info_f ffci
where ff.formula_id = ffci.formula_id
and ff.effective_start_date = ffci.effective_start_date
and ff.effective_end_date = ffci.effective_end_date
and ff.formula_id = p_formula_id;
select ff.formula_name
from ff_formulas_f ff
where ff.formula_id = p_formula_id
and p_calculation_date between
ff.effective_start_date and ff.effective_end_date;
Purpose : To delete all global variables
Returns : 0 if successful, 1 otherwise
---------------------------------------------------------------------*/
function remove_globals return number is
--
l_proc varchar2(72) := g_package||'remove_globals';