APPS.FA_XLA_EXTRACT_DEF_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 391: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */

387:
388: l_last_book varchar2(15) := ' ';
389:
390: cursor c_def_deprn is
391: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */
392: xl.rowid,
393: xb.book_type_code,
394: xl.distribution_id,
395: xl.EXPENSE_ACCOUNT_CCID,

Line 402: fa_xla_ext_headers_b_gt xb,

398: nvl(xl.generated_offset_ccid, da.DEFERRED_RSV_ACCOUNT_CCID),
399: xb.DEFERRED_DEPRN_EXPENSE_ACCT,
400: xb.DEFERRED_DEPRN_RESERVE_ACCT
401: from xla_events_gt xg,
402: fa_xla_ext_headers_b_gt xb,
403: fa_xla_ext_lines_b_gt xl,
404: fa_distribution_accounts da
405: where xg.event_class_code = 'DEFERRED DEPRECIATION'
406: and xb.event_id = xg.event_id