APPS.FA_XLA_EXTRACT_DEF_PKG dependencies on FA_XLA_EXT_LINES_B_GT

Line 205: insert into fa_xla_ext_lines_b_gt (

201: if (not fa_xla_extract_util_pkg.G_secondary_special) then
202:
203:
204:
205: insert into fa_xla_ext_lines_b_gt (
206: EVENT_ID ,
207: LINE_NUMBER ,
208: DISTRIBUTION_ID ,
209: DISTRIBUTION_TYPE_CODE ,

Line 277: insert into fa_xla_ext_lines_b_gt (

273: fa_xla_extract_util_pkg.G_secondary_special) then
274:
275:
276:
277: insert into fa_xla_ext_lines_b_gt (
278: EVENT_ID ,
279: LINE_NUMBER ,
280: DISTRIBUTION_ID ,
281: DISTRIBUTION_TYPE_CODE ,

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 475: fa_xla_ext_lines_b_gt xl,

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
479: and xl.event_id = xg.event_id

Line 567: update fa_xla_ext_lines_b_gt

563:
564: end loop;
565:
566: forall i in 1..l_def_deprn_tbl.count
567: update fa_xla_ext_lines_b_gt
568: set generated_ccid = l_generated_ccid(i),
569: generated_offset_ccid = l_generated_offset_ccid(i)
570: where rowid = l_rowid(i);
571: