APPS.HR_ACCRUAL_PLAN_API dependencies on FF_FORMULAS_F

Line 375: ff_formulas_f_pkg.insert_row(

371: l_formula_name := upper(substr(replace(p_accrual_plan_name, ' ', '_')||
372: '_Oracle_Payroll',
373: 1, 80));
374:
375: ff_formulas_f_pkg.insert_row(
376: X_Rowid => l_rowid,
377: X_Formula_Id => l_formula_id,
378: X_Effective_Start_Date => p_effective_start_date,
379: X_Effective_End_Date => p_effective_end_date,

Line 535: update ff_formulas_f

531: 'PTO_DATE_PAID_CALCULATION_DATE');
532: --
533: end if;
534:
535: update ff_formulas_f
536: set formula_text = l_formula_text
537: where formula_id = l_formula_id;
538:
539: p_formula_id := l_formula_id;

Line 770: from ff_formulas_f ff,

766: -- Cursor to get the PTO skip rule formula ID.
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

Line 1683: from ff_formulas_f ff,

1679: --
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';

Line 2777: from ff_formulas_f ff,

2773: --
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';