APPS.HR_FR_MMO dependencies on FF_FORMULAS_F

Line 16: ln_formula_id ff_formulas.formula_id%TYPE;

12: Function Get_formula (p_business_group_id IN Number,
13: p_session_date IN date) Return Number IS
14: --
15: -- Define Local variable
16: ln_formula_id ff_formulas.formula_id%TYPE;
17: --
18: -- local cursor
19: Cursor Get_user_formula_id (p_business_group_id ff_formulas_f.business_group_id%TYPE,
20: p_formula_name ff_formulas_f.formula_name%TYPE) IS

Line 19: Cursor Get_user_formula_id (p_business_group_id ff_formulas_f.business_group_id%TYPE,

15: -- Define Local variable
16: ln_formula_id ff_formulas.formula_id%TYPE;
17: --
18: -- local cursor
19: Cursor Get_user_formula_id (p_business_group_id ff_formulas_f.business_group_id%TYPE,
20: p_formula_name ff_formulas_f.formula_name%TYPE) IS
21: SELECT ff.formula_id
22: FROM ff_formulas_f ff
23: WHERE ff.business_group_id = p_business_group_id and

Line 20: p_formula_name ff_formulas_f.formula_name%TYPE) IS

16: ln_formula_id ff_formulas.formula_id%TYPE;
17: --
18: -- local cursor
19: Cursor Get_user_formula_id (p_business_group_id ff_formulas_f.business_group_id%TYPE,
20: p_formula_name ff_formulas_f.formula_name%TYPE) IS
21: SELECT ff.formula_id
22: FROM ff_formulas_f ff
23: WHERE ff.business_group_id = p_business_group_id and
24: ff.formula_name = p_formula_name and

Line 22: FROM ff_formulas_f ff

18: -- local cursor
19: Cursor Get_user_formula_id (p_business_group_id ff_formulas_f.business_group_id%TYPE,
20: p_formula_name ff_formulas_f.formula_name%TYPE) IS
21: SELECT ff.formula_id
22: FROM ff_formulas_f ff
23: WHERE ff.business_group_id = p_business_group_id and
24: ff.formula_name = p_formula_name and
25: (p_session_date BETWEEN ff.effective_start_date and ff.effective_end_date);
26: --

Line 28: Cursor Get_template_formula_id (p_legislation_code ff_formulas_f.legislation_code%TYPE,

24: ff.formula_name = p_formula_name and
25: (p_session_date BETWEEN ff.effective_start_date and ff.effective_end_date);
26: --
27:
28: Cursor Get_template_formula_id (p_legislation_code ff_formulas_f.legislation_code%TYPE,
29: p_formula_name ff_formulas_f.formula_name%TYPE) IS
30: SELECT ff.formula_id
31: FROM ff_formulas_f ff
32: WHERE ff.legislation_code = p_legislation_code and

Line 29: p_formula_name ff_formulas_f.formula_name%TYPE) IS

25: (p_session_date BETWEEN ff.effective_start_date and ff.effective_end_date);
26: --
27:
28: Cursor Get_template_formula_id (p_legislation_code ff_formulas_f.legislation_code%TYPE,
29: p_formula_name ff_formulas_f.formula_name%TYPE) IS
30: SELECT ff.formula_id
31: FROM ff_formulas_f ff
32: WHERE ff.legislation_code = p_legislation_code and
33: ff.formula_name = p_formula_name and

Line 31: FROM ff_formulas_f ff

27:
28: Cursor Get_template_formula_id (p_legislation_code ff_formulas_f.legislation_code%TYPE,
29: p_formula_name ff_formulas_f.formula_name%TYPE) IS
30: SELECT ff.formula_id
31: FROM ff_formulas_f ff
32: WHERE ff.legislation_code = p_legislation_code and
33: ff.formula_name = p_formula_name and
34: (p_session_date BETWEEN ff.effective_start_date and ff.effective_end_date);
35:

Line 215: l_formula_id ff_formulas_f.formula_id%TYPE;

211: --
212: -- Define Local Variables
213: --
214: l_proc varchar2(72) := g_package||' Get_reason';
215: l_formula_id ff_formulas_f.formula_id%TYPE;
216: l_effective_start_date ff_formulas_f.effective_start_date%TYPE;
217: l_return_value varchar2(240);
218: l_inputs ff_exec.inputs_t;
219: l_outputs ff_exec.outputs_t;

Line 216: l_effective_start_date ff_formulas_f.effective_start_date%TYPE;

212: -- Define Local Variables
213: --
214: l_proc varchar2(72) := g_package||' Get_reason';
215: l_formula_id ff_formulas_f.formula_id%TYPE;
216: l_effective_start_date ff_formulas_f.effective_start_date%TYPE;
217: l_return_value varchar2(240);
218: l_inputs ff_exec.inputs_t;
219: l_outputs ff_exec.outputs_t;
220: --

Line 229: from ff_formulas_f

225: --
226: hr_utility.set_location(' Initialize formula '||l_proc, 5);
227: select formula_id,effective_start_date
228: into l_formula_id,l_effective_start_date
229: from ff_formulas_f
230: where formula_id = p_formula_id;
231:
232: hr_utility.set_location('formula id found : ' || to_char(l_formula_id),500);
233: