DBA Data[Home] [Help]

APPS.FA_DEPRN_ROLLBACK_PUB dependencies on FA_DEPRN_SUMMARY

Line 461: from fa_deprn_summary ds

457:
458: if (mrc_index = 0) then
459: select count(*)
460: into l_deprn_count
461: from fa_deprn_summary ds
462: where ds.book_type_code = px_asset_hdr_rec.book_type_code
463: and ds.asset_id = px_asset_hdr_rec.asset_id
464: and ds.period_counter = l_period_rec.period_counter;
465: else

Line 468: from fa_deprn_summary_mrc_v ds

464: and ds.period_counter = l_period_rec.period_counter;
465: else
466: select count(*)
467: into l_deprn_count
468: from fa_deprn_summary_mrc_v ds
469: where ds.book_type_code = px_asset_hdr_rec.book_type_code
470: and ds.asset_id = px_asset_hdr_rec.asset_id
471: and ds.period_counter = l_period_rec.period_counter;
472: end if;