eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on FF_COMPILED_INFO_F

Line 4745: DELETE ff_compiled_info_f

4741: -- in the following 2 delete SQLs.
4742: -- 3) Delete Global Value DBIs, then rebuild.
4743: -- 4) PER_BUSINESS_GROUPS -> PER_BUSINESS_GROUPS_PERF
4744: --
4745: DELETE ff_compiled_info_f
4746: WHERE formula_id in (
4747: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */
4748: distinct f.formula_id
4749: FROM ff_formulas_f f,

Line 4771: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_COMPILED_INFO_F');

4767: or (fue.creator_type = 'B'))
4768: )
4769: and bg2.business_group_id(+) = fue.business_group_id
4770: and nvl(fue.legislation_code, bg2.legislation_code) = 'JP');
4771: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_COMPILED_INFO_F');
4772: --
4773: DELETE ff_fdi_usages_f
4774: WHERE formula_id in (
4775: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */