DBA Data[Home] [Help]

APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_MC_DEFERRED_DEPRN

Line 8395: from fa_mc_deferred_deprn df,

8391: gljh.je_batch_id,
8392: df.je_header_id,
8393: decode (df.je_header_id, null, 'N', 'Y'),
8394: glsob.currency_code
8395: from fa_mc_deferred_deprn df,
8396: fa_lookups_tl lk_de,
8397: fa_lookups_tl lk_dr,
8398: gl_je_headers gljh,
8399: gl_sets_of_books glsob

Line 8467: -- Update fa_mc_deferred_deprn table with event_id

8463:
8464:
8465: l_rows_processed := l_event_id_tbl.count;
8466:
8467: -- Update fa_mc_deferred_deprn table with event_id
8468: FORALL l_count IN 1..l_event_id_tbl.count
8469: update fa_mc_deferred_deprn
8470: set event_id = l_event_id_tbl(l_count)
8471: where asset_id = l_asset_id_tbl(l_count)

Line 8469: update fa_mc_deferred_deprn

8465: l_rows_processed := l_event_id_tbl.count;
8466:
8467: -- Update fa_mc_deferred_deprn table with event_id
8468: FORALL l_count IN 1..l_event_id_tbl.count
8469: update fa_mc_deferred_deprn
8470: set event_id = l_event_id_tbl(l_count)
8471: where asset_id = l_asset_id_tbl(l_count)
8472: and corp_book_type_code = l_corp_book_type_code_tbl(l_count)
8473: and tax_book_type_code = l_tax_book_type_code_tbl(l_count)