APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_MC_DEPRN_PERIODS

Line 4482: from fa_mc_deprn_periods dp1,

4478:
4479: -- bug#8496694
4480: select decode(dp1.fiscal_year,dp2.fiscal_year,1,0)
4481: into l_same_fy
4482: from fa_mc_deprn_periods dp1,
4483: fa_mc_deprn_periods dp2
4484: where dp1.book_type_code = h_book
4485: and dp1.set_of_books_id = ret.set_of_books_id
4486: and dp2.set_of_books_id = dp1.set_of_books_id

Line 4483: fa_mc_deprn_periods dp2

4479: -- bug#8496694
4480: select decode(dp1.fiscal_year,dp2.fiscal_year,1,0)
4481: into l_same_fy
4482: from fa_mc_deprn_periods dp1,
4483: fa_mc_deprn_periods dp2
4484: where dp1.book_type_code = h_book
4485: and dp1.set_of_books_id = ret.set_of_books_id
4486: and dp2.set_of_books_id = dp1.set_of_books_id
4487: and dp2.book_type_code = dp1.book_type_code

Line 4497: fa_mc_deprn_periods dp

4493: into l_adj_overlap
4494: from dual
4495: where EXISTS ( Select 'Ret Overlapping Adj'
4496: from fa_transaction_headers th,
4497: fa_mc_deprn_periods dp
4498: where dp.book_type_code = h_book
4499: and dp.set_of_books_id = ret.set_of_books_id
4500: and th.book_type_code = h_book
4501: and th.asset_id = h_asset_id

Line 4679: fa_mc_deprn_periods dp

4675: begin
4676: select count(*)
4677: into h_daily_annual_adj_check
4678: from fa_transaction_headers th,
4679: fa_mc_deprn_periods dp
4680: where dp.book_type_code = h_book
4681: and dp.period_counter = h_start_pd_pc - 1
4682: and dp.set_of_books_id = ret.set_of_books_id
4683: and th.book_type_code = h_book

Line 4811: fa_mc_deprn_periods dp

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
4815: and ds.deprn_source_code = 'BOOKS'