APPS.PER_FORMULA_FUNCTIONS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 74

  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;

Line: 119

  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;

Line: 522

  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;

Line: 837

   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';