APPS.HR_GB_UTILITY dependencies on FF_FORMULAS_F

Line 211: l_formula_id ff_formulas_f.formula_id%type;

207: p_effective_date in date,
208: p_assignment_id in number)
209: return VARCHAR2 IS
210: --
211: l_formula_id ff_formulas_f.formula_id%type;
212: l_effective_start_date ff_formulas_f.effective_start_date%type;
213: l_inputs ff_exec.inputs_t;
214: l_outputs ff_exec.outputs_t;
215: l_return_value varchar2(50):= null;

Line 212: l_effective_start_date ff_formulas_f.effective_start_date%type;

208: p_assignment_id in number)
209: return VARCHAR2 IS
210: --
211: l_formula_id ff_formulas_f.formula_id%type;
212: l_effective_start_date ff_formulas_f.effective_start_date%type;
213: l_inputs ff_exec.inputs_t;
214: l_outputs ff_exec.outputs_t;
215: l_return_value varchar2(50):= null;
216: l_formula_mesg varchar2(50):= null;

Line 227: from ff_formulas_f

223: --
224: BEGIN
225: select formula_id,effective_start_date
226: into l_formula_id, l_effective_start_date
227: from ff_formulas_f
228: where formula_name='TAX_CODE'
229: and business_group_id is null
230: and legislation_code='GB'
231: and p_effective_date between effective_start_date and effective_end_date;