APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on FF_FDI_USAGES_F

Line 4647: ff_fdi_usages_f fdu,

4643: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */
4644: distinct f.formula_id
4645: FROM ff_formulas_f f,
4646: per_business_groups_perf bg,
4647: ff_fdi_usages_f fdu,
4648: ff_database_items fdt,
4649: ff_user_entities fue,
4650: per_business_groups_perf bg2
4651: where (f.legislation_code = 'JP' or f.business_group_id is not null)

Line 4669: DELETE ff_fdi_usages_f

4665: and bg2.business_group_id(+) = fue.business_group_id
4666: and nvl(fue.legislation_code, bg2.legislation_code) = 'JP');
4667: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from FF_COMPILED_INFO_F');
4668: --
4669: DELETE ff_fdi_usages_f
4670: WHERE formula_id in (
4671: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */
4672: distinct f.formula_id
4673: FROM ff_formulas_f f,

Line 4675: ff_fdi_usages_f fdu,

4671: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */
4672: distinct f.formula_id
4673: FROM ff_formulas_f f,
4674: per_business_groups_perf bg,
4675: ff_fdi_usages_f fdu,
4676: ff_database_items fdt,
4677: ff_user_entities fue,
4678: per_business_groups_perf bg2
4679: where (f.legislation_code = 'JP' or f.business_group_id is not null)

Line 4695: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from FF_FDI_USAGES_F');

4691: or (fue.creator_type = 'B'))
4692: )
4693: and bg2.business_group_id(+) = fue.business_group_id
4694: and nvl(fue.legislation_code, bg2.legislation_code) = 'JP');
4695: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from FF_FDI_USAGES_F');
4696: --
4697: -- bug.5758299
4698: DELETE ff_user_entities
4699: WHERE ( legislation_code = 'JP'