APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on PER_BUSINESS_GROUPS_PERF

Line 4743: -- 4) PER_BUSINESS_GROUPS -> PER_BUSINESS_GROUPS_PERF

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

Line 4750: per_business_groups_perf bg,

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

Line 4754: per_business_groups_perf bg2

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

Line 4778: per_business_groups_perf bg,

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

Line 4782: per_business_groups_perf bg2

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

Line 4807: FROM per_business_groups_perf

4803: WHERE ( legislation_code = 'JP'
4804: and creator_type in ('E', 'I', 'B', 'RB', 'CUST', 'S'))
4805: OR ( business_group_id IN (
4806: SELECT business_group_id
4807: FROM per_business_groups_perf
4808: WHERE legislation_code = 'JP')
4809: and creator_type in ('B', 'RB'));
4810: -- hr_utility.trace(SQL%ROWCOUNT || ' rows deleted from FF_USER_ENTITIES');
4811: --

Line 4921: from per_business_groups_perf pbg,

4917: cursor csr_org_df
4918: is
4919: select /*+ ORDERED */
4920: hoi.rowid row_id
4921: from per_business_groups_perf pbg,
4922: hr_all_organization_units hou,
4923: hr_organization_information hoi
4924: where pbg.legislation_code = 'JP'
4925: and hou.business_group_id = pbg.business_group_id

Line 4990: from per_business_groups_perf pbg,

4986: cursor csr_li_ff
4987: is
4988: select /*+ ORDERED */
4989: count(hoi.org_information_id)
4990: from per_business_groups_perf pbg,
4991: hr_all_organization_units hou,
4992: hr_organization_information hoi
4993: where pbg.legislation_code = 'JP'
4994: and hou.business_group_id = pbg.business_group_id