DBA Data[Home] [Help]

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on FF_COMPILED_INFO_F

Line 4641: DELETE ff_compiled_info_f

4637: -- in the following 2 delete SQLs.
4638: -- 3) Delete Global Value DBIs, then rebuild.
4639: -- 4) PER_BUSINESS_GROUPS -> PER_BUSINESS_GROUPS_PERF
4640: --
4641: DELETE ff_compiled_info_f
4642: WHERE formula_id in (
4643: SELECT /*+ ORDERED USE_NL(BG FDU FDT FUE BG2) */
4644: distinct f.formula_id
4645: FROM ff_formulas_f f,

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

4663: or (fue.creator_type = 'B'))
4664: )
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) */