APPS.FA_DEFERRED_DEPRN_PKG dependencies on FA_MC_DEFERRED_DEPRN

Line 429: from fa_mc_deferred_deprn

425: group by asset_id;
426:
427: cursor c_mc_deferred_events (p_set_of_books_id number) is
428: select asset_id, min(rowid)
429: from fa_mc_deferred_deprn
430: where corp_book_type_code = p_corp_book
431: and tax_book_type_code = p_tax_book
432: and corp_period_counter = p_corp_period_counter
433: and tax_period_counter = p_tax_period_counter

Line 563: 'bulk updating fa_mc_deferred_deprn with event ids');

559:
560: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
561: fnd_log.string(G_LEVEL_STATEMENT,
562: G_MODULE_NAME||l_procedure_name,
563: 'bulk updating fa_mc_deferred_deprn with event ids');
564: END IF;
565:
566: -- now process all matching mrc rows
567: FORALL l_count in 1..l_asset_id_tbl.count

Line 568: update fa_mc_deferred_deprn

564: END IF;
565:
566: -- now process all matching mrc rows
567: FORALL l_count in 1..l_asset_id_tbl.count
568: update fa_mc_deferred_deprn
569: SET event_id = l_event_id_tbl(l_count)
570: WHERE asset_id = l_asset_id_tbl(l_count)
571: AND corp_book_type_code = p_corp_book
572: AND tax_book_type_code = p_tax_book

Line 679: 'bulk updating fa_mc_deferred_deprn with event ids');

675:
676: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
677: fnd_log.string(G_LEVEL_STATEMENT,
678: G_MODULE_NAME||l_procedure_name,
679: 'bulk updating fa_mc_deferred_deprn with event ids');
680: END IF;
681:
682: FORALL l_count in 1..l_asset_id_tbl.count
683: UPDATE FA_MC_DEFERRED_DEPRN

Line 683: UPDATE FA_MC_DEFERRED_DEPRN

679: 'bulk updating fa_mc_deferred_deprn with event ids');
680: END IF;
681:
682: FORALL l_count in 1..l_asset_id_tbl.count
683: UPDATE FA_MC_DEFERRED_DEPRN
684: SET event_id = l_event_id_tbl(l_count)
685: WHERE asset_id = l_asset_id_tbl(l_count)
686: AND corp_book_type_code = p_corp_book
687: AND tax_book_type_code = p_tax_book