DBA Data[Home] [Help]

APPS.PAY_FI_GENERAL dependencies on FF_FORMULAS_F

Line 4: g_formula_name ff_formulas_f.formula_name%TYPE;

1: PACKAGE BODY pay_fi_general AS
2: /* $Header: pyfigenr.pkb 120.23.12010000.2 2008/08/19 14:03:04 rmurahar ship $ */
3: --
4: g_formula_name ff_formulas_f.formula_name%TYPE;
5: --
6: g_formula_name ff_formulas_f.formula_name%TYPE;
7: --
8: g_package varchar2(33) := ' PAY_FI_GENERAL.'; -- Global package name

Line 6: g_formula_name ff_formulas_f.formula_name%TYPE;

2: /* $Header: pyfigenr.pkb 120.23.12010000.2 2008/08/19 14:03:04 rmurahar ship $ */
3: --
4: g_formula_name ff_formulas_f.formula_name%TYPE;
5: --
6: g_formula_name ff_formulas_f.formula_name%TYPE;
7: --
8: g_package varchar2(33) := ' PAY_FI_GENERAL.'; -- Global package name
9: g_legislation_code varchar2(150) default null;
10: g_absence_attendance_id number default null;

Line 119: , ff_formulas_f ff

115: ,pay_element_types_f et
116: ,pay_input_values_f iv1
117: ,pay_element_entries_f ee
118: ,pay_element_entry_values_f eev1
119: , ff_formulas_f ff
120: WHERE asg1.assignment_id = p_assignment_id
121: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
122: AND et.element_name = 'Holiday Pay Information'
123: AND et.legislation_code = 'FI'

Line 332: , ff_formulas_f ff

328: ,pay_element_types_f et
329: ,pay_input_values_f iv1
330: ,pay_element_entries_f ee
331: ,pay_element_entry_values_f eev1
332: , ff_formulas_f ff
333: WHERE asg1.assignment_id = p_assignment_id
334: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
335: AND et.element_name = 'Holiday Pay Information'
336: AND et.legislation_code = 'FI'