DBA Data[Home] [Help]

APPS.FA_POLISH_PVT dependencies on FA_MC_DEPRN_SUMMARY

Line 658: from fa_mc_deprn_summary

654: if (p_MRC_SOB_Type_Code = 'R') then
655: Begin /* Bug 6450906 Added Exception handling*/
656: select deprn_reserve
657: into l_first_year_reserve
658: from fa_mc_deprn_summary
659: where book_type_code = p_Book_Type_Code
660: and asset_id = p_Asset_Id
661: and period_counter = l_first_year_period_counter
662: and set_of_books_id = p_set_of_books_id;

Line 671: from fa_mc_deprn_summary

667:
668: Begin /* Bug 6450906 Added Exception handling*/
669: select deprn_reserve
670: into l_prev_year_reserve
671: from fa_mc_deprn_summary
672: where book_type_code = p_Book_Type_Code
673: and asset_id = p_Asset_Id
674: and period_counter = l_prev_year_period_counter
675: and set_of_books_id = p_set_of_books_id;

Line 1625: from fa_mc_deprn_summary

1621:
1622: Begin /* Brahma 6989831. when x_bef_trxn_period_counter is null the following query returns no rows. so adding exception handling */
1623: select deprn_reserve
1624: into x_prev_reserve
1625: from fa_mc_deprn_summary
1626: where book_type_code = p_Book_Type_Code
1627: and asset_id = p_Asset_Id
1628: and period_counter = x_bef_trxn_period_counter
1629: and set_of_books_id = p_set_of_books_id;