APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on FF_FDI_USAGES_F

Line 4751: ff_fdi_usages_f fdu,

4747: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */
4748: distinct f.formula_id
4749: FROM ff_formulas_f f,
4750: per_business_groups_perf bg,
4751: ff_fdi_usages_f fdu,
4752: ff_database_items fdt,
4753: ff_user_entities fue,
4754: per_business_groups_perf bg2
4755: where (f.legislation_code = 'JP' or f.business_group_id is not null)

Line 4773: DELETE ff_fdi_usages_f

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) */
4776: distinct f.formula_id
4777: FROM ff_formulas_f f,

Line 4779: ff_fdi_usages_f fdu,

4775: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */
4776: distinct f.formula_id
4777: FROM ff_formulas_f f,
4778: per_business_groups_perf bg,
4779: ff_fdi_usages_f fdu,
4780: ff_database_items fdt,
4781: ff_user_entities fue,
4782: per_business_groups_perf bg2
4783: where (f.legislation_code = 'JP' or f.business_group_id is not null)

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

4795: or (fue.creator_type = 'B'))
4796: )
4797: and bg2.business_group_id(+) = fue.business_group_id
4798: and nvl(fue.legislation_code, bg2.legislation_code) = 'JP');
4799: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_FDI_USAGES_F');
4800: --
4801: -- bug.5758299
4802: DELETE ff_user_entities
4803: WHERE ( legislation_code = 'JP'