APPS.PAY_US_GARN_UPGRADE dependencies on FF_FORMULAS_F

Line 173: from ff_formulas_f

169:
170: -- Get Formula Text for modification
171: cursor c_formula_text(cp_formula_name varchar2) IS
172: select formula_text
173: from ff_formulas_f
174: where formula_name = cp_formula_name
175: and business_group_id = p_business_grp_id;
176:
177: l_formula_name varchar2(100);

Line 220: update ff_formulas_f

216: l_new_formula_text := replace(l_formula_text,
217: upper(replace(p_new_ele_name, ' ' ,'_')),
218: upper(replace(p_old_ele_name, ' ' ,'_')));
219:
220: update ff_formulas_f
221: set formula_text = l_new_formula_text
222: where formula_name = l_formula_name
223: and business_group_id = p_business_grp_id;
224:

Line 233: from ff_formulas_f

229: */
230: delete
231: from ff_compiled_info
232: where formula_id in (select formula_id
233: from ff_formulas_f
234: where formula_name in (l_formula_name,
235: l_cal_formula_name));
236: delete
237: from ff_fdi_usages

Line 239: from ff_formulas_f

235: l_cal_formula_name));
236: delete
237: from ff_fdi_usages
238: where formula_id in (select formula_id
239: from ff_formulas_f
240: where formula_name in (l_formula_name,
241: l_cal_formula_name));
242:
243: hr_utility.trace('Leaving ' || gv_package_name || '.modify_formula_text');