APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_DEFERRED_DEPRN_EVENTS

Line 8477: -- Add events to fa_deferred_deprn_events table

8473: and tax_book_type_code = l_tax_book_type_code_tbl(l_count)
8474: and corp_period_counter = l_corp_period_counter_tbl(l_count)
8475: and event_id is null;
8476:
8477: -- Add events to fa_deferred_deprn_events table
8478: FOR l_count IN 1..l_event_id_tbl.count LOOP
8479: insert into fa_deferred_deprn_events (
8480: asset_id,
8481: corp_book_type_code,

Line 8479: insert into fa_deferred_deprn_events (

8475: and event_id is null;
8476:
8477: -- Add events to fa_deferred_deprn_events table
8478: FOR l_count IN 1..l_event_id_tbl.count LOOP
8479: insert into fa_deferred_deprn_events (
8480: asset_id,
8481: corp_book_type_code,
8482: tax_book_type_code,
8483: corp_period_counter,

Line 8507: from fa_deferred_deprn_events

8503: from dual
8504: where not exists
8505: (
8506: select 'x'
8507: from fa_deferred_deprn_events
8508: where asset_id = l_asset_id_tbl(l_count)
8509: and corp_book_type_code = l_corp_book_type_code_tbl(l_count)
8510: and corp_period_counter = l_corp_period_counter_tbl(l_count)
8511: and tax_book_type_code = l_tax_book_type_code_tbl(l_count)