DBA Data[Home] [Help]

APPS.HR_LOA_SS dependencies on FF_FORMULAS_F

Line 9315: from ff_formulas_f ff

9311: -- Look for a customer-defined formula
9312: --
9313: select ff.formula_id
9314: into l_formula_id
9315: from ff_formulas_f ff
9316: where ff.formula_name = 'BG_ABSENCE_DURATION'
9317: and ff.business_group_id = p_business_group_id
9318: and p_effective_date between ff.effective_start_date and
9319: ff.effective_end_date;

Line 9333: from ff_formulas_f ff

9329: hr_utility.set_location(l_proc, 25);
9330:
9331: select ff.formula_id
9332: into l_formula_id
9333: from ff_formulas_f ff
9334: where ff.formula_name = 'LEGISLATION_ABSENCE_DURATION'
9335: and ff.legislation_code = l_legislation_code
9336: and ff.business_group_id is null
9337: and p_effective_date between ff.effective_start_date and

Line 9353: from ff_formulas_f ff

9349: hr_utility.set_location(l_proc, 30);
9350:
9351: select ff.formula_id
9352: into l_formula_id
9353: from ff_formulas_f ff
9354: where ff.formula_name = 'CORE_ABSENCE_DURATION'
9355: and ff.legislation_code is null
9356: and ff.business_group_id is null
9357: and p_effective_date between ff.effective_start_date and