DBA Data[Home] [Help]

APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_DEPRN_SUMMARY

Line 2448: fa_deprn_summary ds,

2444: deprn_reserve
2445: INTO h_ytd_deprn, h_pd_num, h_bonus_ytd_deprn, h_fiscal_year,
2446: h_Brow_deprn_reserve /*Bug 7595090 added this variable to get initial depreciation reserve*/
2447: FROM
2448: fa_deprn_summary ds,
2449: fa_deprn_periods dp
2450: WHERE
2451: ds.asset_id = h_asset_id
2452: AND ds.book_type_code = h_book

Line 2464: fa_deprn_summary_mrc_v ds,

2460: deprn_reserve
2461: INTO h_ytd_deprn, h_pd_num, h_bonus_ytd_deprn, h_fiscal_year,
2462: h_Brow_deprn_reserve /*Bug 7595090 added this variable to get initial depreciation reserve*/
2463: FROM
2464: fa_deprn_summary_mrc_v ds,
2465: fa_deprn_periods dp
2466: WHERE
2467: ds.asset_id = h_asset_id
2468: AND ds.book_type_code = h_book

Line 2846: fa_deprn_summary ds,

2842:
2843: SELECT PRIOR_FY_EXPENSE
2844: INTO h_prior_fy_exp
2845: FROM
2846: fa_deprn_summary ds,
2847: fa_deprn_periods dp,
2848: fa_transaction_headers th
2849: WHERE
2850: th.asset_id = h_asset_id