APPS.FA_DEPRN_ROLLBACK_PUB dependencies on FA_MC_DEPRN_SUMMARY

Line 499: from fa_mc_deprn_summary

495: end if;
496:
497: SELECT deprn_run_id
498: into l_secondary_deprn_run_id
499: from fa_mc_deprn_summary
500: where set_of_books_id = l_secondary_exists
501: and book_type_code = px_asset_hdr_rec.book_type_code
502: and period_counter = l_period_rec.period_counter
503: and asset_id = px_asset_hdr_rec.asset_id;

Line 629: from fa_mc_deprn_summary ds

625: and ds.period_counter = l_period_rec.period_counter;
626: else
627: select count(*)
628: into l_deprn_count
629: from fa_mc_deprn_summary ds
630: where ds.book_type_code = px_asset_hdr_rec.book_type_code
631: and ds.asset_id = px_asset_hdr_rec.asset_id
632: and ds.period_counter = l_period_rec.period_counter
633: and ds.set_of_books_id = l_mrc_asset_hdr_rec.set_of_books_id;