DBA Data[Home] [Help]

APPS.FA_XLA_EXTRACT_TRX_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 137: insert into fa_xla_ext_headers_b_gt (

133: if (fa_xla_extract_util_pkg.G_secondary_special) then
134:
135:
136:
137: insert into fa_xla_ext_headers_b_gt (
138: event_id ,
139: DEFAULT_CCID ,
140: BOOK_TYPE_CODE ,
141: PERIOD_NAME ,

Line 252: insert into fa_xla_ext_headers_b_gt (

248: if (not fa_xla_extract_util_pkg.G_secondary_special) then
249:
250:
251:
252: insert into fa_xla_ext_headers_b_gt (
253: event_id ,
254: DEFAULT_CCID ,
255: BOOK_TYPE_CODE ,
256: PERIOD_NAME ,

Line 302: insert into fa_xla_ext_headers_b_gt (

298: if (fa_xla_extract_util_pkg.G_secondary_special) then
299:
300:
301:
302: insert into fa_xla_ext_headers_b_gt (
303: event_id ,
304: DEFAULT_CCID ,
305: BOOK_TYPE_CODE ,
306: PERIOD_NAME ,

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

3932:
3933: l_last_book varchar2(30) := ' ';
3934:
3935: cursor c_trx is
3936: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */
3937: xl.rowid,
3938: xb.book_type_code,
3939: xl.distribution_id,
3940: xl.expense_account_ccid,

Line 4117: fa_xla_ext_headers_b_gt xb,

4113: decode(xl.adjustment_type,
4114: 'BONUS EXPENSE', xl.DEPRN_RESERVE_ACCT,
4115: NULL)
4116: from xla_events_gt xg,
4117: fa_xla_ext_headers_b_gt xb,
4118: fa_xla_ext_lines_b_gt xl,
4119: fa_distribution_accounts da
4120: where xg.event_class_code not in ('DEPRECIATION', 'DEFERRED')
4121: and xb.event_id = xg.event_id