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
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)
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)