8393: and tax_book_type_code = l_tax_book_type_code_tbl(l_count)
8394: and corp_period_counter = l_corp_period_counter_tbl(l_count)
8395: and event_id is null;
8396:
8397: -- Add events to fa_deferred_deprn_events table
8398: FOR l_count IN 1..l_event_id_tbl.count LOOP
8399: insert into fa_deferred_deprn_events (
8400: asset_id,
8401: corp_book_type_code,
8395: and event_id is null;
8396:
8397: -- Add events to fa_deferred_deprn_events table
8398: FOR l_count IN 1..l_event_id_tbl.count LOOP
8399: insert into fa_deferred_deprn_events (
8400: asset_id,
8401: corp_book_type_code,
8402: tax_book_type_code,
8403: corp_period_counter,
8423: from dual
8424: where not exists
8425: (
8426: select 'x'
8427: from fa_deferred_deprn_events
8428: where asset_id = l_asset_id_tbl(l_count)
8429: and corp_book_type_code = l_corp_book_type_code_tbl(l_count)
8430: and corp_period_counter = l_corp_period_counter_tbl(l_count)
8431: and tax_book_type_code = l_tax_book_type_code_tbl(l_count)