DBA Data[Home] [Help]

APPS.HR_LOA_SS dependencies on FF_FORMULAS_F

Line 9537: from ff_formulas_f ff

9533: -- Look for a customer-defined formula
9534: --
9535: select ff.formula_id
9536: into l_formula_id
9537: from ff_formulas_f ff
9538: where ff.formula_name = 'BG_ABSENCE_DURATION'
9539: and ff.business_group_id = p_business_group_id
9540: and p_effective_date between ff.effective_start_date and
9541: ff.effective_end_date;

Line 9555: from ff_formulas_f ff

9551: hr_utility.set_location(l_proc, 25);
9552:
9553: select ff.formula_id
9554: into l_formula_id
9555: from ff_formulas_f ff
9556: where ff.formula_name = 'LEGISLATION_ABSENCE_DURATION'
9557: and ff.legislation_code = l_legislation_code
9558: and ff.business_group_id is null
9559: and p_effective_date between ff.effective_start_date and

Line 9575: from ff_formulas_f ff

9571: hr_utility.set_location(l_proc, 30);
9572:
9573: select ff.formula_id
9574: into l_formula_id
9575: from ff_formulas_f ff
9576: where ff.formula_name = 'CORE_ABSENCE_DURATION'
9577: and ff.legislation_code is null
9578: and ff.business_group_id is null
9579: and p_effective_date between ff.effective_start_date and