DBA Data[Home] [Help]

APPS.PER_ABS_BUS dependencies on FF_FORMULAS_F

Line 1080: from ff_formulas_f ff

1076: -- Look for a customer-defined formula
1077: --
1078: select ff.formula_id
1079: into l_formula_id
1080: from ff_formulas_f ff
1081: where ff.formula_name = 'BG_ABSENCE_DURATION'
1082: and ff.business_group_id = p_business_group_id
1083: and p_effective_date between ff.effective_start_date and
1084: ff.effective_end_date;

Line 1098: from ff_formulas_f ff

1094: hr_utility.set_location(l_proc, 25);
1095:
1096: select ff.formula_id
1097: into l_formula_id
1098: from ff_formulas_f ff
1099: where ff.formula_name = 'LEGISLATION_ABSENCE_DURATION'
1100: and ff.legislation_code = l_legislation_code
1101: and ff.business_group_id is null
1102: and p_effective_date between ff.effective_start_date and

Line 1117: from ff_formulas_f ff

1113: hr_utility.set_location(l_proc, 30);
1114:
1115: select ff.formula_id
1116: into l_formula_id
1117: from ff_formulas_f ff
1118: where ff.formula_name = 'CORE_ABSENCE_DURATION'
1119: and ff.legislation_code is null
1120: and ff.business_group_id is null
1121: and p_effective_date between ff.effective_start_date and