APPS.HR_CAL_ABS_DUR_PKG dependencies on FF_FORMULAS_F

Line 208: l_formula_id ff_formulas_f.formula_id%type;

204: p_use_formula IN OUT NOCOPY VARCHAR2) IS
205: --
206: --
207: --
208: l_formula_id ff_formulas_f.formula_id%type;
209: l_effective_start_date ff_formulas_f.effective_start_date%type;
210: l_inputs ff_exec.inputs_t;
211: l_outputs ff_exec.outputs_t;
212: wrong_parameters exception;

Line 209: l_effective_start_date ff_formulas_f.effective_start_date%type;

205: --
206: --
207: --
208: l_formula_id ff_formulas_f.formula_id%type;
209: l_effective_start_date ff_formulas_f.effective_start_date%type;
210: l_inputs ff_exec.inputs_t;
211: l_outputs ff_exec.outputs_t;
212: wrong_parameters exception;
213: l_user_message VARCHAR2(1);

Line 257: from ff_formulas_f

253: -- select customer-defined formula (if exists)
254: begin
255: select formula_id, effective_start_date
256: into l_formula_id, l_effective_start_date
257: from ff_formulas_f
258: where formula_name = 'BG_ABSENCE_DURATION'
259: and business_group_id = p_business_group_id
260: and p_session_date between effective_start_date and effective_end_date;
261: exception

Line 268: from ff_formulas_f

264: -- legislation-defined formula
265: begin
266: select formula_id, effective_start_date
267: into l_formula_id, l_effective_start_date
268: from ff_formulas_f
269: where formula_name = 'LEGISLATION_ABSENCE_DURATION'
270: and legislation_code = p_legislation_code
271: and business_group_id is null
272: and p_session_date between effective_start_date and effective_end_date;

Line 280: from ff_formulas_f

276: -- select core formula
277: begin
278: select formula_id, effective_start_date
279: into l_formula_id, l_effective_start_date
280: from ff_formulas_f
281: where formula_name = 'CORE_ABSENCE_DURATION'
282: and legislation_code is null
283: and business_group_id is null
284: and p_session_date between effective_start_date and effective_end_date;