APPS.PER_ABS_BUS dependencies on FF_FORMULAS_F

Line 1249: from ff_formulas_f ff

1245: -- Look for a customer-defined formula
1246: --
1247: select ff.formula_id
1248: into l_formula_id
1249: from ff_formulas_f ff
1250: where ff.formula_name = 'BG_ABSENCE_DURATION'
1251: and ff.business_group_id = p_business_group_id
1252: and p_effective_date between ff.effective_start_date and
1253: ff.effective_end_date;

Line 1267: from ff_formulas_f ff

1263: hr_utility.set_location(l_proc, 25);
1264:
1265: select ff.formula_id
1266: into l_formula_id
1267: from ff_formulas_f ff
1268: where ff.formula_name = 'LEGISLATION_ABSENCE_DURATION'
1269: and ff.legislation_code = l_legislation_code
1270: and ff.business_group_id is null
1271: and p_effective_date between ff.effective_start_date and

Line 1286: from ff_formulas_f ff

1282: hr_utility.set_location(l_proc, 30);
1283:
1284: select ff.formula_id
1285: into l_formula_id
1286: from ff_formulas_f ff
1287: where ff.formula_name = 'CORE_ABSENCE_DURATION'
1288: and ff.legislation_code is null
1289: and ff.business_group_id is null
1290: and p_effective_date between ff.effective_start_date and