DBA Data[Home] [Help]

APPS.PAY_1099R_FORMULA_DRIVER dependencies on FF_COMPILED_INFO_F

Line 255: -- FF_FORMULAS_F, FF_FDI_USAGES_F and FF_COMPILED_INFO_F tables.

251: -- DELETION STEPS
252: -- **************************************************************************
253: --
254: -- This part of the procedure deletes all previous definitions from the
255: -- FF_FORMULAS_F, FF_FDI_USAGES_F and FF_COMPILED_INFO_F tables.
256: --
257: l_message := 'Attempting to delete previous definitions of 1099R federal
258: formulas from FF_COMPILED_INFO_F for formula - ' ||
259: l_formula_name_table(l_count);

Line 258: formulas from FF_COMPILED_INFO_F for formula - ' ||

254: -- This part of the procedure deletes all previous definitions from the
255: -- FF_FORMULAS_F, FF_FDI_USAGES_F and FF_COMPILED_INFO_F tables.
256: --
257: l_message := 'Attempting to delete previous definitions of 1099R federal
258: formulas from FF_COMPILED_INFO_F for formula - ' ||
259: l_formula_name_table(l_count);
260: --
261: -- Delete all cases where 1099R Federal Formulas have been compiled
262: -- from FF_COMPILED_INFO_F

Line 262: -- from FF_COMPILED_INFO_F

258: formulas from FF_COMPILED_INFO_F for formula - ' ||
259: l_formula_name_table(l_count);
260: --
261: -- Delete all cases where 1099R Federal Formulas have been compiled
262: -- from FF_COMPILED_INFO_F
263: --
264: delete from ff_compiled_info_f fci
265: where fci.formula_id in (select ff.formula_id
266: from ff_formulas_f ff

Line 264: delete from ff_compiled_info_f fci

260: --
261: -- Delete all cases where 1099R Federal Formulas have been compiled
262: -- from FF_COMPILED_INFO_F
263: --
264: delete from ff_compiled_info_f fci
265: where fci.formula_id in (select ff.formula_id
266: from ff_formulas_f ff
267: where formula_name = l_formula_name_table(l_count));
268: --