APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_DEPRN_SUMMARY

Line 2697: fa_deprn_summary ds,

2693: ytd_impairment, deprn_reserve
2694: INTO h_ytd_deprn, h_pd_num, h_bonus_ytd_deprn, h_fiscal_year,
2695: h_ytd_impairment, h_Brow_deprn_reserve
2696: FROM
2697: fa_deprn_summary ds,
2698: fa_deprn_periods dp
2699: WHERE
2700: ds.asset_id = h_asset_id
2701: AND ds.book_type_code = h_book

Line 3607: fa_deprn_summary ds,

3603:
3604: SELECT PRIOR_FY_EXPENSE
3605: INTO h_prior_fy_exp
3606: FROM
3607: fa_deprn_summary ds,
3608: fa_deprn_periods dp,
3609: fa_transaction_headers th
3610: WHERE
3611: th.asset_id = h_asset_id

Line 4438: from fa_deprn_summary

4434: if mrc_sob_type_code <> 'R' then
4435:
4436: select period_counter + 1
4437: into h_asset_addition_pc
4438: from fa_deprn_summary
4439: where asset_id = h_asset_id
4440: and book_type_code = h_book
4441: and deprn_source_code = 'BOOKS';
4442:

Line 4793: from fa_deprn_summary ds,

4789: if mrc_sob_type_code <> 'R' then
4790: begin
4791: select 1
4792: into l_poa_ret
4793: from fa_deprn_summary ds,
4794: fa_deprn_periods dp
4795: where ds.book_type_code = h_book
4796: and ds.asset_id = h_asset_id
4797: and ds.deprn_source_code = 'BOOKS'

Line 4976: from fa_deprn_summary

4972: begin
4973: if mrc_sob_type_code <> 'R' then
4974: select period_counter + 1
4975: into h_asset_addition_pc
4976: from fa_deprn_summary
4977: where asset_id = h_asset_id
4978: and book_type_code = h_book
4979: and deprn_source_code = 'BOOKS';
4980: else