APPS.BEN_DETERMINE_DATE dependencies on FF_FORMULAS_F

Line 154: from ff_formula_types fft,ff_formulas_f ff

150:
151: cursor c_formula_type_id_name
152: is
153: select fft.formula_type_id,fft.formula_type_name
154: from ff_formula_types fft,ff_formulas_f ff
155: where ff.formula_id=p_formula_id
156: and ff.formula_type_id= fft.formula_type_id
157: and p_effective_date between ff.effective_start_date and ff.effective_end_date;
158:

Line 203: l_formula_type_id ff_formulas_f.formula_type_id%type;

199: l_message_name2 varchar2(500) := 'BEN_94464_ENROL_ED_DT_RANGE';
200: l_message_name3 varchar2(500) := 'BEN_93964_ENRO_DT_LT_LE_OCD_DT';
201:
202:
203: l_formula_type_id ff_formulas_f.formula_type_id%type;
204: l_formula_type_name ff_formula_types.formula_type_name%type;
205: l_pgm_name ben_pgm_f.name%type;
206: l_pl_name ben_pl_f.name%type;
207: l_opt_name ben_opt_f.name%type;