DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_TRX_PKG dependencies on FA_XLA_EXT_HEADERS_B_GT

Line 62: insert into fa_xla_ext_headers_b_gt (

58: 'Beginning of procedure');
59: END IF;
60:
61:
62: insert into fa_xla_ext_headers_b_gt (
63: event_id ,
64: DEFAULT_CCID ,
65: BOOK_TYPE_CODE ,
66: PERIOD_NAME ,

Line 178: insert into fa_xla_ext_headers_b_gt (

174: 'Beginning of procedure');
175: END IF;
176:
177:
178: insert into fa_xla_ext_headers_b_gt (
179: event_id ,
180: DEFAULT_CCID ,
181: BOOK_TYPE_CODE ,
182: PERIOD_NAME ,

Line 2902: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */

2898:
2899: l_last_book varchar2(15) := ' ';
2900:
2901: cursor c_trx is
2902: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */
2903: xl.rowid,
2904: xb.book_type_code,
2905: xl.distribution_id,
2906: xl.expense_account_ccid,

Line 3020: fa_xla_ext_headers_b_gt xb,

3016: 'EXPENSE', xl.DEPRN_RESERVE_ACCT,
3017: 'BONUS EXPENSE', xl.BONUS_RESERVE_ACCT,
3018: NULL)
3019: from xla_events_gt xg,
3020: fa_xla_ext_headers_b_gt xb,
3021: fa_xla_ext_lines_b_gt xl,
3022: fa_distribution_accounts da
3023: where xg.event_class_code not in ('DEPRECIATION', 'DEFERRED')
3024: and xb.event_id = xg.event_id