APPS.FA_XLA_EXTRACT_DEPRN_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 108: insert into fa_xla_ext_headers_b_gt (

104: if (fa_xla_extract_util_pkg.G_secondary_special) then
105:
106:
107:
108: insert into fa_xla_ext_headers_b_gt (
109: event_id ,
110: DEFAULT_CCID ,
111: BOOK_TYPE_CODE ,
112: PERIOD_NAME ,

Line 184: INSERT INTO FA_XLA_EXT_HEADERS_B_GT (

180: END IF;
181:
182: if (NOT fa_xla_extract_util_pkg.G_secondary_special) then
183:
184: INSERT INTO FA_XLA_EXT_HEADERS_B_GT (
185: event_id ,
186: period_close_date ,
187: reversal_flag ,
188: transfer_to_gl_flag ,

Line 217: INSERT INTO FA_XLA_EXT_HEADERS_B_GT (

213: end if;
214:
215: IF (fa_xla_extract_util_pkg.G_secondary_special) then
216:
217: INSERT INTO FA_XLA_EXT_HEADERS_B_GT (
218: event_id ,
219: period_close_date ,
220: reversal_flag ,
221: transfer_to_gl_flag ,

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

678:
679: l_last_book varchar2(30) := ' ';
680:
681: cursor c_deprn is
682: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */
683: xl.rowid,
684: xb.book_type_code,
685: xl.distribution_id,
686: xl.EXPENSE_ACCOUNT_CCID,

Line 715: fa_xla_ext_headers_b_gt xb,

711: xl.REVAL_RESERVE_ACCT,
712: xl.CAPITAL_ADJ_ACCT,
713: xl.GENERAL_FUND_ACCT
714: from xla_events_gt xg,
715: fa_xla_ext_headers_b_gt xb,
716: fa_xla_ext_lines_b_gt xl,
717: fa_distribution_accounts da
718: where xg.event_class_code = 'DEPRECIATION'
719: and xb.event_id = xg.event_id