APPS.PAY_US_RSRW_UPGREV dependencies on FF_FORMULAS_F

Line 51: 13-Nov-2011 emunisek 115.8 13484606 Replaced FF_FORMULAS_F.FORMULA_TEXT%TYPE

47: Added assignment_status_type_id
48: in Proration Event Group.
49: 06-Jul-2009 sudedas 115.7 8637053 Added context element_type_id to
50: function get_payprd_per_fiscal_yr
51: 13-Nov-2011 emunisek 115.8 13484606 Replaced FF_FORMULAS_F.FORMULA_TEXT%TYPE
52: for variables based on formula_text column.
53: *****************************************************************************/
54:
55: /************************************************************

Line 74: from ff_formulas_f ff

70:
71: -- Get Formula Text for modification
72: cursor c_formula_id(cp_formula_name varchar2) IS
73: select ff.formula_id
74: from ff_formulas_f ff
75: ,ff_formula_types ft
76: where ff.formula_name = cp_formula_name
77: and ff.formula_type_id = ft.formula_type_id
78: and ft.formula_type_name = 'Oracle Payroll'

Line 84: l_old_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;

80: and ff.legislation_code = 'US';
81:
82: l_formula_id number;
83: l_formula_name varchar2(100);
84: l_old_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
85: l_new_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
86:
87: BEGIN
88: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');

Line 85: l_new_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;

81:
82: l_formula_id number;
83: l_formula_name varchar2(100);
84: l_old_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
85: l_new_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
86:
87: BEGIN
88: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');
89: hr_utility.trace('Passed Parameter p_ele_name := ' || p_ele_name);

Line 2038: update ff_formulas_f

2034:
2035: hr_utility.trace('Updating Formula Text in Mode := ' || p_mode);
2036:
2037: BEGIN
2038: update ff_formulas_f
2039: set formula_text = l_new_formula_text
2040: where formula_name = l_formula_name
2041: and business_group_id IS NULL
2042: and legislation_code = 'US';

Line 2057: update ff_formulas_f

2053: ELSIF p_mode = 'OLD' THEN
2054:
2055: hr_utility.trace('Updating Formula Text in Mode := ' || p_mode);
2056: BEGIN
2057: update ff_formulas_f
2058: set formula_text = l_old_formula_text
2059: where formula_name = l_formula_name
2060: and business_group_id IS NULL
2061: and legislation_code = 'US';