APPS.PAY_ES_BENEFIT_UPLIFT_CALC dependencies on FF_FORMULAS_F

Line 8: g_gross_per_day_formula_id ff_formulas_f.formula_id%TYPE;

4: -- Global Variables
5: hr_formula_error EXCEPTION;
6: g_gross_per_day_formula_exists BOOLEAN := TRUE;
7: g_gross_per_day_formula_cached BOOLEAN := FALSE;
8: g_gross_per_day_formula_id ff_formulas_f.formula_id%TYPE;
9: g_gross_per_day_formula_name ff_formulas_f.formula_name%TYPE;
10: --
11: g_duration_formula_exists BOOLEAN := TRUE;
12: g_duration_formula_cached BOOLEAN := FALSE;

Line 9: g_gross_per_day_formula_name ff_formulas_f.formula_name%TYPE;

5: hr_formula_error EXCEPTION;
6: g_gross_per_day_formula_exists BOOLEAN := TRUE;
7: g_gross_per_day_formula_cached BOOLEAN := FALSE;
8: g_gross_per_day_formula_id ff_formulas_f.formula_id%TYPE;
9: g_gross_per_day_formula_name ff_formulas_f.formula_name%TYPE;
10: --
11: g_duration_formula_exists BOOLEAN := TRUE;
12: g_duration_formula_cached BOOLEAN := FALSE;
13: g_duration_formula_id ff_formulas_f.formula_id%TYPE;

Line 13: g_duration_formula_id ff_formulas_f.formula_id%TYPE;

9: g_gross_per_day_formula_name ff_formulas_f.formula_name%TYPE;
10: --
11: g_duration_formula_exists BOOLEAN := TRUE;
12: g_duration_formula_cached BOOLEAN := FALSE;
13: g_duration_formula_id ff_formulas_f.formula_id%TYPE;
14: g_duration_formula_name ff_formulas_f.formula_name%TYPE;
15: -------------------------------------------------------------------------------
16: -- FUNCTION get_gross_per_day
17: -------------------------------------------------------------------------------

Line 14: g_duration_formula_name ff_formulas_f.formula_name%TYPE;

10: --
11: g_duration_formula_exists BOOLEAN := TRUE;
12: g_duration_formula_cached BOOLEAN := FALSE;
13: g_duration_formula_id ff_formulas_f.formula_id%TYPE;
14: g_duration_formula_name ff_formulas_f.formula_name%TYPE;
15: -------------------------------------------------------------------------------
16: -- FUNCTION get_gross_per_day
17: -------------------------------------------------------------------------------
18: FUNCTION get_gross_per_day(p_assignment_id IN NUMBER

Line 28: l_formula_id ff_formulas_f.formula_id%TYPE;

24: l_inputs ff_exec.inputs_t;
25: l_outputs ff_exec.outputs_t;
26: l_formula_exists BOOLEAN := TRUE;
27: l_formula_cached BOOLEAN := FALSE;
28: l_formula_id ff_formulas_f.formula_id%TYPE;
29: l_gross_per_day VARCHAR2(500);
30: --
31: BEGIN
32: -- hr_utility.trace_on(null,'EFT');

Line 111: l_formula_id ff_formulas_f.formula_id%TYPE;

107: l_inputs ff_exec.inputs_t;
108: l_outputs ff_exec.outputs_t;
109: l_formula_exists BOOLEAN := TRUE;
110: l_formula_cached BOOLEAN := FALSE;
111: l_formula_id ff_formulas_f.formula_id%TYPE;
112: l_return_indicator VARCHAR2(1);
113: --
114: BEGIN
115: -- hr_utility.trace_on(null,'EFT');

Line 272: FROM ff_formulas_f ff

268:
269: --
270: CURSOR c_compiled_formula_exist IS
271: SELECT 'Y'
272: FROM ff_formulas_f ff
273: ,ff_compiled_info_f ffci
274: WHERE ff.formula_id = ffci.formula_id
275: AND ff.effective_start_date = ffci.effective_start_date
276: AND ff.effective_end_date = ffci.effective_end_date

Line 282: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE

278: AND ff.business_group_id = p_business_group_id
279: AND p_effective_date BETWEEN ff.effective_start_date
280: AND ff.effective_end_date;
281: --
282: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE
283: ,p_effective_date DATE) IS
284: SELECT ff.formula_id
285: FROM ff_formulas_f ff
286: WHERE ff.formula_name = p_formula_name

Line 285: FROM ff_formulas_f ff

281: --
282: CURSOR c_get_formula(p_formula_name ff_formulas_f.formula_name%TYPE
283: ,p_effective_date DATE) IS
284: SELECT ff.formula_id
285: FROM ff_formulas_f ff
286: WHERE ff.formula_name = p_formula_name
287: AND ff.business_group_id = p_business_group_id
288: AND p_effective_date BETWEEN ff.effective_start_date
289: AND ff.effective_end_date;