APPS.FA_DEPRN_EVENTS_PKG dependencies on FA_MC_DEFERRED_DEPRN

Line 452: from fa_mc_deferred_deprn

448: p_tax_period_counter number
449: ) IS
450: select rowid,
451: asset_id
452: from fa_mc_deferred_deprn
453: where set_of_books_id = p_set_of_books_id
454: and corp_book_type_code = p_corp_book_type_code
455: and tax_book_type_code = p_tax_book_type_code
456: and corp_period_counter = p_corp_period_counter

Line 523: UPDATE FA_MC_DEFERRED_DEPRN

519: WHERE rowid = l_rowid_tbl(l_count);
520:
521: -- now process all matching mrc rows
522: FORALL l_count in 1..l_asset_id_tbl.count
523: UPDATE FA_MC_DEFERRED_DEPRN
524: SET event_id = l_event_id_tbl(l_count)
525: WHERE asset_id = l_asset_id_tbl(l_count)
526: AND corp_book_type_code = p_corp_book_type_code
527: AND tax_book_type_code = p_tax_book_type_code

Line 600: UPDATE FA_MC_DEFERRED_DEPRN

596: p_calling_fn => l_calling_fn,
597: p_log_level_rec => g_log_level_rec);
598:
599: FORALL l_count in 1..l_asset_id_tbl.count
600: UPDATE FA_MC_DEFERRED_DEPRN
601: SET event_id = l_event_id_tbl(l_count)
602: WHERE rowid = l_rowid_tbl(l_count);
603:
604: -- now process all matching mrc rows

Line 606: UPDATE FA_MC_DEFERRED_DEPRN

602: WHERE rowid = l_rowid_tbl(l_count);
603:
604: -- now process all matching mrc rows
605: FORALL l_count in 1..l_asset_id_tbl.count
606: UPDATE FA_MC_DEFERRED_DEPRN
607: SET event_id = l_event_id_tbl(l_count)
608: WHERE set_of_books_id <> l_sob_tbl(l_sob_index)
609: AND asset_id = l_asset_id_tbl(l_count)
610: AND corp_book_type_code = p_corp_book_type_code