APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on FF_USER_ENTITIES

Line 4703: ff_user_entities fue,

4699: select fdi.user_entity_id,
4700: fdi.user_name,
4701: fdi.description
4702: from ff_globals_f fg,
4703: ff_user_entities fue,
4704: ff_database_items fdi
4705: where fg.legislation_code = 'JP'
4706: and fg.effective_start_date = (
4707: select max(fg2.effective_start_date)

Line 4753: ff_user_entities fue,

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

Line 4781: ff_user_entities fue,

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

Line 4802: DELETE ff_user_entities

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'
4804: and creator_type in ('E', 'I', 'B', 'RB', 'CUST', 'S'))
4805: OR ( business_group_id IN (
4806: SELECT business_group_id

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

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: --
4812: -- bug.6040440
4813: -- Rebuild Global Values DBIs.
4814: --

Line 6734: from ff_user_entities fue,

6730: cursor csr_corrupt_dbi_tl
6731: is
6732: select /*+ ORDERED */
6733: count(fdit.user_name)
6734: from ff_user_entities fue,
6735: ff_database_items fdi,
6736: ff_database_items_tl fdit
6737: where (fue.user_entity_name like 'T_SAL_ITX_DAY1_KOU%'
6738: or fue.user_entity_name like 'T_SAL_ITX_DAY2_KOU%BASIC%')

Line 6800: from ff_user_entities fue,

6796: ufdit.last_update_date = sysdate
6797: where ufdit.rowid in (
6798: select /*+ ORDERD */
6799: fdit.rowid
6800: from ff_user_entities fue,
6801: ff_database_items fdi,
6802: ff_database_items_tl fdit
6803: where (fue.user_entity_name like 'T_SAL_ITX_DAY1_KOU%'
6804: or fue.user_entity_name like 'T_SAL_ITX_DAY2_KOU%BASIC%')