DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_DEPRN_SUMMARY

Line 6834: from fa_deprn_summary ds,

6830: nvl(cb.reval_reserve_account_ccid, -1)
6831: default_reval_rsv_ccid,
6832: nvl(bc.je_depreciation_category, 'OTHER')
6833: je_category_name
6834: from fa_deprn_summary ds,
6835: fa_book_controls bc,
6836: gl_sets_of_books glsob,
6837: fa_deprn_periods dp,
6838: fa_asset_history ah,

Line 7182: from fa_deprn_summary ds,

7178: and dd.asset_id = ds.asset_id
7179: and dd.period_counter = ds.period_counter
7180: and nvl(dd.je_header_id,-1) > 0) je_hdr_id, -- Bug 6811554
7181: bc.gl_posting_allowed_flag gl_posting_allowed_flag
7182: from fa_deprn_summary ds,
7183: fa_book_controls bc,
7184: gl_sets_of_books glsob,
7185: fa_deprn_periods dp,
7186: fa_asset_history ah,

Line 7216: -- Update fa_deprn_summary table with event_id

7212: and dp.xla_conversion_status is not null;
7213:
7214: end if;
7215:
7216: -- Update fa_deprn_summary table with event_id
7217: update /*+ rowid(ds) */
7218: fa_deprn_summary ds
7219: set ds.event_id =
7220: ( select ev.event_id

Line 7218: fa_deprn_summary ds

7214: end if;
7215:
7216: -- Update fa_deprn_summary table with event_id
7217: update /*+ rowid(ds) */
7218: fa_deprn_summary ds
7219: set ds.event_id =
7220: ( select ev.event_id
7221: from fa_xla_upg_events_gt ev
7222: where ev.ds_asset_id = ds.asset_id