DBA Data[Home] [Help]

APPS.FA_AMORT_PVT dependencies on FA_MC_DEPRN_SUMMARY

Line 3638: from fa_mc_deprn_summary

3634: and set_of_books_id = p_asset_hdr_rec.set_of_books_id;
3635:
3636: CURSOR c_get_ytd_deprn_mrc IS
3637: select ytd_deprn,deprn_reserve
3638: from fa_mc_deprn_summary
3639: where book_type_code = p_asset_hdr_rec.book_type_code
3640: and asset_id = p_reclassed_asset_id
3641: and period_counter = l_mem_period_counter
3642: and deprn_source_code = 'BOOKS'

Line 12377: from fa_mc_deprn_summary

12373: and deprn_source_code = 'BOOKS';
12374:
12375: CURSOR c_get_mc_brow IS
12376: select ytd_deprn, deprn_reserve
12377: from fa_mc_deprn_summary
12378: where asset_id = p_asset_hdr_rec.asset_id
12379: and book_type_code = p_asset_hdr_rec.book_type_code
12380: and deprn_source_code = 'BOOKS'
12381: and set_of_books_id = p_asset_hdr_rec.set_of_books_id;

Line 16427: from fa_mc_deprn_summary

16423: into l_deprn_summary.deprn_rsv,
16424: l_deprn_summary.bonus_deprn_rsv,
16425: l_deprn_summary.ytd_deprn,
16426: l_deprn_summary.impairment_rsv
16427: from fa_mc_deprn_summary
16428: where asset_id = p_asset_hdr_rec.asset_id
16429: and book_type_code = p_asset_hdr_rec.book_type_code
16430: and deprn_source_code = 'BOOKS'
16431: and set_of_books_id = p_asset_hdr_rec.set_of_books_id;