DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_MC_DEFERRED_DEPRN

Line 8315: from fa_mc_deferred_deprn df,

8311: gljh.je_batch_id,
8312: df.je_header_id,
8313: decode (df.je_header_id, null, 'N', 'Y'),
8314: glsob.currency_code
8315: from fa_mc_deferred_deprn df,
8316: fa_lookups_tl lk_de,
8317: fa_lookups_tl lk_dr,
8318: gl_je_headers gljh,
8319: gl_sets_of_books glsob

Line 8387: -- Update fa_mc_deferred_deprn table with event_id

8383:
8384:
8385: l_rows_processed := l_event_id_tbl.count;
8386:
8387: -- Update fa_mc_deferred_deprn table with event_id
8388: FORALL l_count IN 1..l_event_id_tbl.count
8389: update fa_mc_deferred_deprn
8390: set event_id = l_event_id_tbl(l_count)
8391: where asset_id = l_asset_id_tbl(l_count)

Line 8389: update fa_mc_deferred_deprn

8385: l_rows_processed := l_event_id_tbl.count;
8386:
8387: -- Update fa_mc_deferred_deprn table with event_id
8388: FORALL l_count IN 1..l_event_id_tbl.count
8389: update fa_mc_deferred_deprn
8390: set event_id = l_event_id_tbl(l_count)
8391: where asset_id = l_asset_id_tbl(l_count)
8392: and corp_book_type_code = l_corp_book_type_code_tbl(l_count)
8393: and tax_book_type_code = l_tax_book_type_code_tbl(l_count)