APPS.PAY_JP_YEA_BAL_ADJ_PKG dependencies on FF_FORMULAS_F

Line 19: l_pay_formula_id ff_formulas_f.formula_id%type;

15: p_payroll_id in varchar2,
16: p_effective_date in varchar2
17: ) RETURN varchar2 IS
18: --
19: l_pay_formula_id ff_formulas_f.formula_id%type;
20: l_org_formula_id ff_formulas_f.formula_id%type;
21: --
22: l_formula_name ff_formulas_f_tl.formula_name%type;
23: --

Line 20: l_org_formula_id ff_formulas_f.formula_id%type;

16: p_effective_date in varchar2
17: ) RETURN varchar2 IS
18: --
19: l_pay_formula_id ff_formulas_f.formula_id%type;
20: l_org_formula_id ff_formulas_f.formula_id%type;
21: --
22: l_formula_name ff_formulas_f_tl.formula_name%type;
23: --
24: cursor c_org_formula is

Line 22: l_formula_name ff_formulas_f_tl.formula_name%type;

18: --
19: l_pay_formula_id ff_formulas_f.formula_id%type;
20: l_org_formula_id ff_formulas_f.formula_id%type;
21: --
22: l_formula_name ff_formulas_f_tl.formula_name%type;
23: --
24: cursor c_org_formula is
25: select fnd_number.canonical_to_number(org_information5)
26: from hr_organization_information

Line 39: from ff_formulas_f ff, ff_formulas_f_tl fft

35: between effective_start_date and effective_end_date;
36: --
37: cursor c_formula is
38: select fft.formula_name
39: from ff_formulas_f ff, ff_formulas_f_tl fft
40: where ff.formula_id = nvl(l_pay_formula_id, l_org_formula_id)
41: and fnd_date.canonical_to_date(p_effective_date)
42: between ff.effective_start_date and ff.effective_end_date
43: and fft.formula_id = ff.formula_id