DBA Data[Home] [Help]

APPS.FF_CLIENT_ENGINE SQL Statements

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

Line: 364

  select fff.formula_id
  into   l_formula_id
  from   ff_formulas_f    fff,
         ff_formula_types fft
  where  fft.formula_type_name = p_formula_type_name
  and    fff.formula_type_id   = fft.formula_type_id
  and    fff.formula_name      = p_formula_name
  and    p_effective_date between
         fff.effective_start_date and fff.effective_end_date;