APPS.FA_GAINLOSS_UND_PKG dependencies on FA_DEPRN_SUMMARY

Line 4469: /*** Retrieve FA_DEPRN_SUMMARY.PRIOR_FY_EXPENSE. ***/

4465: element => 'reserve (Before Retirement)',
4466: value => '');
4467: end if;
4468:
4469: /*** Retrieve FA_DEPRN_SUMMARY.PRIOR_FY_EXPENSE. ***/
4470: /*** and Year-to-date depreciation. ***/
4471:
4472: if (ret.mrc_sob_type_code <> 'R') then
4473:

Line 4480: FROM fa_deprn_summary fads, fa_deprn_periods fadp

4476: nvl(fads.impairment_reserve, 0)
4477: INTO h_deprn_reserve, h_bonus_deprn_reserve, h_reval_reserve,
4478: h_prior_fy_expense, h_ytd_deprn,
4479: h_impairment_reserve
4480: FROM fa_deprn_summary fads, fa_deprn_periods fadp
4481: WHERE fads.asset_id = h_asset_id
4482: AND fads.book_type_Code = h_book
4483: AND fads.period_counter = fadp.period_counter
4484: AND fadp.period_counter =

Line 4486: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS

4482: AND fads.book_type_Code = h_book
4483: AND fads.period_counter = fadp.period_counter
4484: AND fadp.period_counter =
4485: (select MAX(DP.PERIOD_COUNTER)
4486: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS
4487: WHERE DP.BOOK_TYPE_CODE = h_book
4488: AND DP.PERIOD_COUNTER = DS.PERIOD_COUNTER
4489: AND DP.PERIOD_COUNTER < h_pd_counter
4490: AND DS.BOOK_TYPE_CODE = h_book