APPS.FA_XLA_EXTRACT_DEPRN_PKG dependencies on FA_XLA_EXT_LINES_B_GT

Line 198: insert into fa_xla_ext_lines_b_gt (

194: 'Beginning of procedure');
195: END IF;
196:
197:
198: insert into fa_xla_ext_lines_b_gt (
199: EVENT_ID ,
200: LINE_NUMBER ,
201: DISTRIBUTION_ID ,
202: DISTRIBUTION_TYPE_CODE ,

Line 302: insert into fa_xla_ext_lines_b_gt (

298: if (fa_xla_extract_util_pkg.G_alc_enabled) then
299:
300:
301:
302: insert into fa_xla_ext_lines_b_gt (
303: EVENT_ID ,
304: LINE_NUMBER ,
305: DISTRIBUTION_ID ,
306: DISTRIBUTION_TYPE_CODE ,

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

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

Line 750: update fa_xla_ext_lines_b_gt

746:
747: end loop;
748:
749: forall i in 1..l_deprn_tbl.count
750: update fa_xla_ext_lines_b_gt
751: set generated_ccid = l_generated_ccid(i),
752: generated_offset_ccid = l_generated_offset_ccid(i),
753: bonus_generated_ccid = l_bonus_generated_ccid(i),
754: bonus_generated_offset_ccid = l_bonus_generated_offset_ccid(i),