DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_DEPRN_SUMMARY

Line 6806: from fa_deprn_summary ds,

6802: nvl(cb.reval_reserve_account_ccid, -1)
6803: default_reval_rsv_ccid,
6804: nvl(bc.je_depreciation_category, 'OTHER')
6805: je_category_name
6806: from fa_deprn_summary ds,
6807: fa_book_controls bc,
6808: gl_sets_of_books glsob,
6809: fa_deprn_periods dp,
6810: fa_asset_history ah,

Line 7140: from fa_deprn_summary ds,

7136: nvl(cb.reval_reserve_account_ccid, -1)
7137: default_reval_rsv_ccid,
7138: nvl(bc.je_depreciation_category, 'OTHER')
7139: je_category_name
7140: from fa_deprn_summary ds,
7141: fa_book_controls bc,
7142: gl_sets_of_books glsob,
7143: fa_deprn_periods dp,
7144: fa_asset_history ah,

Line 7171: -- Update fa_deprn_summary table with event_id

7167: and dp.xla_conversion_status is not null;
7168:
7169: end if;
7170:
7171: -- Update fa_deprn_summary table with event_id
7172: update /*+ rowid(ds) */
7173: fa_deprn_summary ds
7174: set ds.event_id =
7175: ( select ev.event_id

Line 7173: fa_deprn_summary ds

7169: end if;
7170:
7171: -- Update fa_deprn_summary table with event_id
7172: update /*+ rowid(ds) */
7173: fa_deprn_summary ds
7174: set ds.event_id =
7175: ( select ev.event_id
7176: from fa_xla_upg_events_gt ev
7177: where ev.ds_asset_id = ds.asset_id