DBA Data[Home] [Help]

APPS.PAY_1099R_FORMULA_DRIVER dependencies on FF_FDI_USAGES_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 270: formulas from FF_FDI_USAGES_F for formula - ' ||

266: from ff_formulas_f ff
267: where formula_name = l_formula_name_table(l_count));
268: --
269: l_message := 'Attempting to delete previous definitions of 1099R federal
270: formulas from FF_FDI_USAGES_F for formula - ' ||
271: l_formula_name_table(l_count);
272: --
273: -- Delete all cases where 1099R Federal Formulas have been compiled
274: -- from FF_FDI_USAGES_F

Line 274: -- from FF_FDI_USAGES_F

270: formulas from FF_FDI_USAGES_F for formula - ' ||
271: l_formula_name_table(l_count);
272: --
273: -- Delete all cases where 1099R Federal Formulas have been compiled
274: -- from FF_FDI_USAGES_F
275: --
276: delete from ff_fdi_usages_f
277: where formula_id in (select formula_id
278: from ff_formulas_f

Line 276: delete from ff_fdi_usages_f

272: --
273: -- Delete all cases where 1099R Federal Formulas have been compiled
274: -- from FF_FDI_USAGES_F
275: --
276: delete from ff_fdi_usages_f
277: where formula_id in (select formula_id
278: from ff_formulas_f
279: where formula_name = l_formula_name_table(l_count));
280: --