APPS.FA_XLA_EXTRACT_DEPRN_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 129: INSERT INTO FA_XLA_EXT_HEADERS_B_GT (

125: G_MODULE_NAME||l_procedure_name||'.begin',
126: 'Beginning of procedure');
127: END IF;
128:
129: INSERT INTO FA_XLA_EXT_HEADERS_B_GT (
130: event_id ,
131: period_close_date ,
132: reversal_flag ,
133: transfer_to_gl_flag ,

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

539:
540: l_last_book varchar2(15) := ' ';
541:
542: cursor c_deprn is
543: select /*+ leading(xg) index(xb, FA_XLA_EXT_HEADERS_B_GT_U1) index(xl, FA_XLA_EXT_LINES_B_GT_U1) */
544: xl.rowid,
545: xb.book_type_code,
546: xl.distribution_id,
547: xl.EXPENSE_ACCOUNT_CCID,

Line 570: fa_xla_ext_headers_b_gt xb,

566: xl.BONUS_RESERVE_ACCT,
567: xl.REVAL_AMORT_ACCT,
568: xl.REVAL_RESERVE_ACCT
569: from xla_events_gt xg,
570: fa_xla_ext_headers_b_gt xb,
571: fa_xla_ext_lines_b_gt xl,
572: fa_distribution_accounts da
573: where xg.event_class_code = 'DEPRECIATION'
574: and xb.event_id = xg.event_id