DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_XLA_UPG_EVENTS_GT

Line 4190: into fa_xla_upg_events_gt (

4186: and lookup_code = 'BONUS DEPRECIATION RESERVE';
4187:
4188: insert all
4189: when 1 = 1 then
4190: into fa_xla_upg_events_gt (
4191: event_id,
4192: entity_id,
4193: transaction_header_id,
4194: set_of_books_id,

Line 4657: from fa_xla_upg_events_gt ev

4653: update /*+ rowid(th) */
4654: fa_transaction_headers th
4655: set th.event_id = nvl(
4656: ( select ev.event_id
4657: from fa_xla_upg_events_gt ev
4658: where ev.transaction_header_id = th.transaction_header_id
4659: and ev.book_type_code = th.book_type_code
4660: ), th.event_id)
4661: where th.rowid between p_start_rowid and p_end_rowid;

Line 5376: fa_xla_upg_events_gt ev,

5372: (partition by ev.transaction_header_id
5373: order by adj.adjustment_line_id, mult.adj_row) ae_line_num,
5374: mult.adj_row adj_row
5375: from
5376: fa_xla_upg_events_gt ev,
5377: fa_xla_upg_headers_gt he,
5378: fa_adjustments adj,
5379: fa_lookups_tl lk,
5380: fa_lookups_tl lk2,

Line 5576: from fa_xla_upg_events_gt faev,

5572: calendar_period_close_date,
5573: faev.period_name period_name,
5574: faev.je_category_name je_category_name,
5575: faev.description description
5576: from fa_xla_upg_events_gt faev,
5577: fa_mc_book_controls mc
5578: where mc.book_type_code = faev.book_type_code
5579: and mc.enabled_flag = 'Y';
5580:

Line 6295: fa_xla_upg_events_gt ev,

6291: adj.set_of_books_id
6292: order by adj.adjustment_line_id, mult.adj_row) ae_line_num,
6293: mult.adj_row adj_row
6294: from
6295: fa_xla_upg_events_gt ev,
6296: fa_xla_upg_headers_gt he,
6297: fa_mc_adjustments adj,
6298: fa_lookups_tl lk,
6299: fa_lookups_tl lk2,

Line 6497: into fa_xla_upg_events_gt (

6493: if (p_mode = 'downtime') then
6494:
6495: insert all
6496: when 1 = 1 then
6497: into fa_xla_upg_events_gt (
6498: event_id,
6499: entity_id,
6500: set_of_books_id,
6501: period_name,

Line 6831: into fa_xla_upg_events_gt (

6827: else
6828:
6829: insert all
6830: when 1 = 1 then
6831: into fa_xla_upg_events_gt (
6832: event_id,
6833: entity_id,
6834: set_of_books_id,
6835: period_name,

Line 7176: from fa_xla_upg_events_gt ev

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
7178: and ev.ds_book_type_code = ds.book_type_code
7179: and ev.ds_period_counter = ds.period_counter
7180: ),

Line 7548: from fa_xla_upg_events_gt ev,

7544: (partition by ev.event_id
7545: order by dd.distribution_id, mult.multiplier)
7546: ae_line_num,
7547: mult.multiplier multiplier
7548: from fa_xla_upg_events_gt ev,
7549: fa_xla_upg_headers_gt he,
7550: fa_deprn_detail dd,
7551: fa_distribution_history dh,
7552: fa_distribution_accounts da,

Line 7718: from fa_xla_upg_events_gt faev,

7714: calendar_period_close_date,
7715: faev.period_name period_name,
7716: faev.je_category_name je_category_name,
7717: faev.description description
7718: from fa_xla_upg_events_gt faev,
7719: fa_mc_book_controls mc
7720: where mc.book_type_code = faev.ds_book_type_code
7721: and mc.enabled_flag = 'Y';
7722:

Line 8064: from fa_xla_upg_events_gt ev,

8060: (partition by ev.event_id
8061: order by dd.distribution_id, mult.multiplier)
8062: ae_line_num,
8063: mult.multiplier multiplier
8064: from fa_xla_upg_events_gt ev,
8065: fa_xla_upg_headers_gt he,
8066: fa_mc_deprn_detail dd,
8067: fa_distribution_history dh,
8068: fa_distribution_accounts da,