APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 4639: -- 4) PER_BUSINESS_GROUPS -> PER_BUSINESS_GROUPS_PERF

4635: -- 2) Both B and RB user entities need to be deleted.
4636: -- No DBIs for RB user entities, so no need to specify RB
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) */

Line 4646: per_business_groups_perf bg,

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,
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

Line 4650: per_business_groups_perf bg2

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)
4652: and bg.business_group_id(+) = f.business_group_id
4653: and nvl(f.legislation_code, bg.legislation_code) = 'JP'
4654: and fdu.formula_id = f.formula_id

Line 4674: per_business_groups_perf bg,

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,
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

Line 4678: per_business_groups_perf bg2

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)
4680: and bg.business_group_id(+) = f.business_group_id
4681: and nvl(f.legislation_code, bg.legislation_code) = 'JP'
4682: and fdu.formula_id = f.formula_id

Line 4703: FROM per_business_groups_perf

4699: WHERE ( legislation_code = 'JP'
4700: and creator_type in ('E', 'I', 'B', 'RB', 'CUST', 'S'))
4701: OR ( business_group_id IN (
4702: SELECT business_group_id
4703: FROM per_business_groups_perf
4704: WHERE legislation_code = 'JP')
4705: and creator_type in ('B', 'RB'));
4706: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from FF_USER_ENTITIES');
4707: --

Line 4761: from per_business_groups_perf pbg,

4757: cursor csr_org_df
4758: is
4759: select /*+ ORDERED */
4760: hoi.rowid row_id
4761: from per_business_groups_perf pbg,
4762: hr_all_organization_units hou,
4763: hr_organization_information hoi
4764: where pbg.legislation_code = 'JP'
4765: and hou.business_group_id = pbg.business_group_id

Line 4830: from per_business_groups_perf pbg,

4826: cursor csr_li_ff
4827: is
4828: select /*+ ORDERED */
4829: count(hoi.org_information_id)
4830: from per_business_groups_perf pbg,
4831: hr_all_organization_units hou,
4832: hr_organization_information hoi
4833: where pbg.legislation_code = 'JP'
4834: and hou.business_group_id = pbg.business_group_id