APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_MC_DEPRN_SUMMARY

Line 2713: fa_mc_deprn_summary ds,

2709: ytd_impairment, deprn_reserve
2710: INTO h_ytd_deprn, h_pd_num, h_bonus_ytd_deprn, h_fiscal_year,
2711: h_ytd_impairment, h_Brow_deprn_reserve
2712: FROM
2713: fa_mc_deprn_summary ds,
2714: fa_deprn_periods dp
2715: WHERE
2716: ds.asset_id = h_asset_id
2717: AND ds.book_type_code = h_book

Line 3635: fa_mc_deprn_summary ds,

3631:
3632: SELECT PRIOR_FY_EXPENSE
3633: INTO h_prior_fy_exp
3634: FROM
3635: fa_mc_deprn_summary ds,
3636: fa_deprn_periods dp,
3637: fa_transaction_headers th
3638: WHERE
3639: th.asset_id = h_asset_id

Line 4473: from fa_mc_deprn_summary

4469: else
4470:
4471: select period_counter + 1
4472: into h_asset_addition_pc
4473: from fa_mc_deprn_summary
4474: where asset_id = h_asset_id
4475: and book_type_code = h_book
4476: and set_of_books_id = ret.set_of_books_id
4477: and deprn_source_code = 'BOOKS';

Line 4810: from fa_mc_deprn_summary ds,

4806: else
4807: begin
4808: select 1
4809: into l_poa_ret
4810: from fa_mc_deprn_summary ds,
4811: fa_mc_deprn_periods dp
4812: where ds.book_type_code = h_book
4813: and ds.set_of_books_id = ret.set_of_books_id
4814: and ds.asset_id = h_asset_id

Line 4983: from fa_mc_deprn_summary

4979: and deprn_source_code = 'BOOKS';
4980: else
4981: select period_counter + 1
4982: into h_asset_addition_pc
4983: from fa_mc_deprn_summary
4984: where asset_id = h_asset_id
4985: and book_type_code = h_book
4986: and set_of_books_id = ret.set_of_books_id
4987: and deprn_source_code = 'BOOKS';