DBA Data[Home] [Help]

APPS.FA_GAINLOSS_UND_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 4502: FROM fa_mc_deprn_summary fads, fa_deprn_periods fadp

4498: nvl(fads.impairment_reserve, 0)
4499: INTO h_deprn_reserve, h_bonus_deprn_reserve, h_reval_reserve,
4500: h_prior_fy_expense, h_ytd_deprn,
4501: h_impairment_reserve
4502: FROM fa_mc_deprn_summary fads, fa_deprn_periods fadp
4503: WHERE fads.asset_id = h_asset_id
4504: AND fads.book_type_Code = h_book
4505: AND fads.period_counter = fadp.period_counter
4506: AND fads.set_of_books_id = ret.set_of_books_id

Line 4509: FROM FA_DEPRN_PERIODS DP, FA_MC_DEPRN_SUMMARY DS

4505: AND fads.period_counter = fadp.period_counter
4506: AND fads.set_of_books_id = ret.set_of_books_id
4507: AND fadp.period_counter =
4508: (select MAX(DP.PERIOD_COUNTER)
4509: FROM FA_DEPRN_PERIODS DP, FA_MC_DEPRN_SUMMARY DS
4510: WHERE DP.BOOK_TYPE_CODE = h_book
4511: AND DP.PERIOD_COUNTER = DS.PERIOD_COUNTER
4512: AND DP.PERIOD_COUNTER < h_pd_counter
4513: AND DS.set_of_books_id = ret.set_of_books_id