APPS.HR_ACCRUAL_PLAN_API dependencies on FF_FORMULA_TYPES

Line 368: from ff_formula_types

364: l_update_date := sysdate;
365:
366: select formula_type_id
367: into l_formula_type_id
368: from ff_formula_types
369: where formula_type_name = 'Oracle Payroll';
370:
371: l_formula_name := upper(substr(replace(p_accrual_plan_name, ' ', '_')||
372: '_Oracle_Payroll',

Line 771: ff_formula_types ft

767: --
768: cursor c_get_skip_rule (p_formula_name in varchar2) is
769: select ff.formula_id
770: from ff_formulas_f ff,
771: ff_formula_types ft
772: where ff.formula_type_id = ft.formula_type_id
773: and ft.formula_type_name = 'Element Skip'
774: and ff.formula_name = p_formula_name
775: and p_effective_date between ff.effective_start_date

Line 1684: ff_formula_types ft

1680:
1681: select formula_id
1682: into l_tagging_formula_id
1683: from ff_formulas_f ff,
1684: ff_formula_types ft
1685: where ff.formula_type_id = ft.formula_type_id
1686: and ft.formula_type_name = 'Oracle Payroll'
1687: and ff.formula_name = 'PTO_TAGGING_FORMULA';
1688:

Line 2778: ff_formula_types ft

2774:
2775: select formula_id
2776: into l_tagging_formula_id
2777: from ff_formulas_f ff,
2778: ff_formula_types ft
2779: where ff.formula_type_id = ft.formula_type_id
2780: and ft.formula_type_name = 'Oracle Payroll'
2781: and ff.formula_name = 'PTO_TAGGING_FORMULA';
2782: