APPS.FA_XLA_EXTRACT_DEF_PKG dependencies on FA_XLA_EXT_HEADERS_B_GT

Line 66: insert into fa_xla_ext_headers_b_gt (

62: if (not fa_xla_extract_util_pkg.G_secondary_special) then
63:
64:
65:
66: insert into fa_xla_ext_headers_b_gt (
67: event_id ,
68: DEFAULT_CCID ,
69: BOOK_TYPE_CODE ,
70: PERIOD_NAME ,

Line 111: insert into fa_xla_ext_headers_b_gt (

107: if (fa_xla_extract_util_pkg.G_secondary_special) then
108:
109:
110:
111: insert into fa_xla_ext_headers_b_gt (
112: event_id ,
113: DEFAULT_CCID ,
114: BOOK_TYPE_CODE ,
115: PERIOD_NAME ,

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

459:
460: l_last_book varchar2(30) := ' ';
461:
462: cursor c_def_deprn is
463: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */
464: xl.rowid,
465: xb.book_type_code,
466: xl.distribution_id,
467: xl.EXPENSE_ACCOUNT_CCID,

Line 474: fa_xla_ext_headers_b_gt xb,

470: nvl(xl.generated_offset_ccid, da.DEFERRED_RSV_ACCOUNT_CCID),
471: xb.DEFERRED_DEPRN_EXPENSE_ACCT,
472: xb.DEFERRED_DEPRN_RESERVE_ACCT
473: from xla_events_gt xg,
474: fa_xla_ext_headers_b_gt xb,
475: fa_xla_ext_lines_b_gt xl,
476: fa_distribution_accounts da
477: where xg.event_class_code = 'DEFERRED DEPRECIATION'
478: and xb.event_id = xg.event_id