APPS.HR_GB_UTILITY dependencies on FF_FORMULAS_F

Line 191: l_formula_id ff_formulas_f.formula_id%type;

187: p_effective_date in date,
188: p_assignment_id in number)
189: return VARCHAR2 IS
190: --
191: l_formula_id ff_formulas_f.formula_id%type;
192: l_effective_start_date ff_formulas_f.effective_start_date%type;
193: l_inputs ff_exec.inputs_t;
194: l_outputs ff_exec.outputs_t;
195: l_return_value varchar2(50):= null;

Line 192: l_effective_start_date ff_formulas_f.effective_start_date%type;

188: p_assignment_id in number)
189: return VARCHAR2 IS
190: --
191: l_formula_id ff_formulas_f.formula_id%type;
192: l_effective_start_date ff_formulas_f.effective_start_date%type;
193: l_inputs ff_exec.inputs_t;
194: l_outputs ff_exec.outputs_t;
195: l_return_value varchar2(50):= null;
196: l_formula_mesg varchar2(50):= null;

Line 207: from ff_formulas_f

203: --
204: BEGIN
205: select formula_id,effective_start_date
206: into l_formula_id, l_effective_start_date
207: from ff_formulas_f
208: where formula_name='TAX_CODE'
209: and business_group_id is null
210: and legislation_code='GB'
211: and p_effective_date between effective_start_date and effective_end_date;