APPS.FA_XLA_EXTRACT_DEPRN_PKG dependencies on FA_XLA_EXT_LINES_B_GT

Line 297: insert into fa_xla_ext_lines_b_gt (

293: if (not fa_xla_extract_util_pkg.G_secondary_special) then
294:
295:
296:
297: insert into fa_xla_ext_lines_b_gt (
298: EVENT_ID ,
299: LINE_NUMBER ,
300: DISTRIBUTION_ID ,
301: DISTRIBUTION_TYPE_CODE ,

Line 417: insert into fa_xla_ext_lines_b_gt (

413: fa_xla_extract_util_pkg.G_secondary_special) then
414:
415:
416:
417: insert into fa_xla_ext_lines_b_gt (
418: EVENT_ID ,
419: LINE_NUMBER ,
420: DISTRIBUTION_ID ,
421: DISTRIBUTION_TYPE_CODE ,

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

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

Line 941: update fa_xla_ext_lines_b_gt

937:
938: end loop;
939:
940: forall i in 1..l_deprn_tbl.count
941: update fa_xla_ext_lines_b_gt
942: set generated_ccid = l_generated_ccid(i),
943: generated_offset_ccid = l_generated_offset_ccid(i),
944: bonus_generated_ccid = l_bonus_generated_ccid(i),
945: bonus_generated_offset_ccid = l_bonus_generated_offset_ccid(i),