APPS.FA_SLA_EVENTS_UPG_PKG dependencies on FA_DEFERRED_DEPRN

Line 8307: from fa_deferred_deprn df,

8303: df.corp_period_counter,
8304: df.tax_period_counter,
8305: glsob.currency_code,
8306: nvl (bc.je_deferred_deprn_category, 'OTHER') je_category_name
8307: from fa_deferred_deprn df,
8308: fa_deprn_periods dp,
8309: gl_sets_of_books glsob,
8310: fa_book_controls bc,
8311: fa_lookups_tl lk_de,

Line 8353: from fa_deferred_deprn df,

8349: lk_dr.description,
8350: gljh.je_batch_id,
8351: df.je_header_id,
8352: decode (df.je_header_id, null, 'N', 'Y')
8353: from fa_deferred_deprn df,
8354: fa_lookups_tl lk_de,
8355: fa_lookups_tl lk_dr,
8356: gl_je_headers gljh
8357: where df.corp_book_type_code = l_corp_book_type_code

Line 8453: -- Update fa_deferred_deprn table with event_id

8449: from dual;
8450:
8451: END LOOP;
8452:
8453: -- Update fa_deferred_deprn table with event_id
8454: FORALL l_count IN 1..l_event_id_tbl.count
8455: update fa_deferred_deprn
8456: set event_id = l_event_id_tbl(l_count)
8457: where rowid between p_start_rowid and p_end_rowid

Line 8455: update fa_deferred_deprn

8451: END LOOP;
8452:
8453: -- Update fa_deferred_deprn table with event_id
8454: FORALL l_count IN 1..l_event_id_tbl.count
8455: update fa_deferred_deprn
8456: set event_id = l_event_id_tbl(l_count)
8457: where rowid between p_start_rowid and p_end_rowid
8458: and asset_id = l_asset_id_tbl(l_count)
8459: and corp_book_type_code = l_corp_book_type_code_tbl(l_count)

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)