eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_GAINLOSS_UND_PKG dependencies on FA_DEPRN_SUMMARY

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

3973: element => 'reserve (Before Retirement)',
3974: value => '');
3975: end if;
3976:
3977: /*** Retrieve FA_DEPRN_SUMMARY.PRIOR_FY_EXPENSE. ***/
3978: /*** and Year-to-date depreciation. ***/
3979:
3980: if (ret.mrc_sob_type_code <> 'R') then
3981:

Line 3986: FROM fa_deprn_summary fads, fa_deprn_periods fadp

3982: SELECT fads.deprn_reserve, fads.bonus_deprn_reserve, fads.reval_reserve,
3983: nvl(fads.prior_fy_expense, 0), nvl(fads.ytd_deprn, 0)
3984: INTO h_deprn_reserve, h_bonus_deprn_reserve, h_reval_reserve, h_prior_fy_expense,
3985: h_ytd_deprn
3986: FROM fa_deprn_summary fads, fa_deprn_periods fadp
3987: WHERE fads.asset_id = h_asset_id
3988: AND fads.book_type_Code = h_book
3989: AND fads.period_counter = fadp.period_counter
3990: AND fadp.period_counter =

Line 3992: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS

3988: AND fads.book_type_Code = h_book
3989: AND fads.period_counter = fadp.period_counter
3990: AND fadp.period_counter =
3991: (select MAX(DP.PERIOD_COUNTER)
3992: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS
3993: WHERE DP.BOOK_TYPE_CODE = h_book
3994: AND DP.PERIOD_COUNTER = DS.PERIOD_COUNTER
3995: AND DP.PERIOD_COUNTER < h_pd_counter
3996: AND DS.BOOK_TYPE_CODE = h_book

Line 4006: FROM fa_deprn_summary_mrc_v fads, fa_deprn_periods fadp

4002: SELECT fads.deprn_reserve, fads.bonus_deprn_reserve, fads.reval_reserve,
4003: nvl(fads.prior_fy_expense, 0), nvl(fads.ytd_deprn, 0)
4004: INTO h_deprn_reserve, h_bonus_deprn_reserve, h_reval_reserve, h_prior_fy_expense,
4005: h_ytd_deprn
4006: FROM fa_deprn_summary_mrc_v fads, fa_deprn_periods fadp
4007: WHERE fads.asset_id = h_asset_id
4008: AND fads.book_type_Code = h_book
4009: AND fads.period_counter = fadp.period_counter
4010: AND fadp.period_counter =

Line 4012: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS