DBA Data[Home] [Help]

APPS.FA_POLISH_PVT dependencies on FA_DEPRN_SUMMARY

Line 777: from fa_deprn_summary

773: else
774: Begin /* Bug 6450906 Added Exception handling*/
775: select deprn_reserve
776: into l_first_year_reserve
777: from fa_deprn_summary
778: where book_type_code = p_Book_Type_Code
779: and asset_id = p_Asset_Id
780: and period_counter = l_first_year_period_counter;
781: Exception

Line 789: from fa_deprn_summary

785:
786: Begin /* Bug 6450906 Added Exception handling*/
787: select deprn_reserve
788: into l_prev_year_reserve
789: from fa_deprn_summary
790: where book_type_code = p_Book_Type_Code
791: and asset_id = p_Asset_Id
792: and period_counter = l_prev_year_period_counter;
793: Exception

Line 1721: from fa_deprn_summary

1717:
1718: Begin /* Brahma 6989831. when x_bef_trxn_period_counter is null the following query returns no rows. so adding exception handling */
1719: select deprn_reserve
1720: into x_prev_reserve
1721: from fa_deprn_summary
1722: where book_type_code = p_Book_Type_Code
1723: and asset_id = p_Asset_Id
1724: and period_counter = x_bef_trxn_period_counter;
1725: Exception