DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_XLA_UPG_EVENTS_GT

Line 4285: into fa_xla_upg_events_gt (

4281: and lookup_code = 'BONUS DEPRECIATION RESERVE';
4282:
4283: insert all
4284: when 1 = 1 then
4285: into fa_xla_upg_events_gt (
4286: event_id,
4287: entity_id,
4288: transaction_header_id,
4289: set_of_books_id,

Line 4795: from fa_xla_upg_events_gt ev

4791: update /*+ rowid(th) */
4792: fa_transaction_headers th
4793: set th.event_id = nvl(
4794: ( select ev.event_id
4795: from fa_xla_upg_events_gt ev
4796: where ev.transaction_header_id = th.transaction_header_id
4797: and ev.book_type_code = th.book_type_code
4798: ), th.event_id)
4799: where th.rowid between p_start_rowid and p_end_rowid;

Line 5515: fa_xla_upg_events_gt ev,

5511: (partition by ev.transaction_header_id
5512: order by adj.adjustment_line_id, mult.adj_row) ae_line_num,
5513: mult.adj_row adj_row
5514: from
5515: fa_xla_upg_events_gt ev,
5516: fa_xla_upg_headers_gt he,
5517: fa_adjustments adj,
5518: fa_lookups_tl lk,
5519: fa_lookups_tl lk2,

Line 5715: from fa_xla_upg_events_gt faev,

5711: calendar_period_close_date,
5712: faev.period_name period_name,
5713: faev.je_category_name je_category_name,
5714: faev.description description
5715: from fa_xla_upg_events_gt faev,
5716: fa_mc_book_controls mc
5717: where mc.book_type_code = faev.book_type_code
5718: and mc.enabled_flag = 'Y';
5719:

Line 6434: fa_xla_upg_events_gt ev,

6430: adj.set_of_books_id
6431: order by adj.adjustment_line_id, mult.adj_row) ae_line_num,
6432: mult.adj_row adj_row
6433: from
6434: fa_xla_upg_events_gt ev,
6435: fa_xla_upg_headers_gt he,
6436: fa_mc_adjustments adj,
6437: fa_lookups_tl lk,
6438: fa_lookups_tl lk2,

Line 6637: into fa_xla_upg_events_gt (

6633: if (p_mode = 'downtime') then
6634:
6635: insert all
6636: when 1 = 1 then
6637: into fa_xla_upg_events_gt (
6638: event_id,
6639: entity_id,
6640: set_of_books_id,
6641: period_name,

Line 6862: into fa_xla_upg_events_gt (

6858: else
6859:
6860: insert all
6861: when 1 = 1 then
6862: into fa_xla_upg_events_gt (
6863: event_id,
6864: entity_id,
6865: set_of_books_id,
6866: period_name,

Line 7221: from fa_xla_upg_events_gt ev

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
7223: and ev.ds_book_type_code = ds.book_type_code
7224: and ev.ds_period_counter = ds.period_counter
7225: ),

Line 7622: from fa_xla_upg_events_gt ev,

7618: (partition by ev.event_id
7619: order by dd.distribution_id, mult.multiplier)
7620: ae_line_num,
7621: mult.multiplier multiplier
7622: from fa_xla_upg_events_gt ev,
7623: fa_xla_upg_headers_gt he,
7624: fa_deprn_detail dd,
7625: fa_distribution_history dh,
7626: fa_distribution_accounts da,

Line 7795: from fa_xla_upg_events_gt faev,

7791: calendar_period_close_date,
7792: faev.period_name period_name,
7793: faev.je_category_name je_category_name,
7794: faev.description description
7795: from fa_xla_upg_events_gt faev,
7796: fa_mc_book_controls mc
7797: where mc.book_type_code = faev.ds_book_type_code
7798: and mc.enabled_flag = 'Y';
7799:

Line 8144: from fa_xla_upg_events_gt ev,

8140: (partition by ev.event_id
8141: order by dd.distribution_id, mult.multiplier)
8142: ae_line_num,
8143: mult.multiplier multiplier
8144: from fa_xla_upg_events_gt ev,
8145: fa_xla_upg_headers_gt he,
8146: fa_mc_deprn_detail dd,
8147: fa_distribution_history dh,
8148: fa_distribution_accounts da,