APPS.FA_GROUP_RECLASS2_PVT dependencies on FA_MC_DEPRN_PERIODS

Line 2138: fa_mc_deprn_periods dp1

2134:
2135: cursor MEM_EXP_RESERVE_MRC is
2136: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
2137: from fa_mc_deprn_summary ds1,
2138: fa_mc_deprn_periods dp1
2139: where ds1.book_type_code = h_book_type_code
2140: and ds1.asset_id = h_member_asset_id
2141: and dp1.book_type_code = ds1.book_type_Code
2142: and dp1.period_counter = ds1.period_counter

Line 2233: from fa_mc_deprn_periods dp1,

2229: and adj.source_type_code = 'ADJUSTMENT'
2230: and adj.set_of_books_id = h_set_of_books_id
2231: and adj.period_counter_adjusted in
2232: (select dp2.period_counter
2233: from fa_mc_deprn_periods dp1,
2234: fa_mc_deprn_periods dp2
2235: where dp1.book_type_code = adj.book_type_code
2236: and dp1.period_counter = h_period_counter - 1
2237: and dp1.set_of_books_id = h_set_of_books_id

Line 2234: fa_mc_deprn_periods dp2

2230: and adj.set_of_books_id = h_set_of_books_id
2231: and adj.period_counter_adjusted in
2232: (select dp2.period_counter
2233: from fa_mc_deprn_periods dp1,
2234: fa_mc_deprn_periods dp2
2235: where dp1.book_type_code = adj.book_type_code
2236: and dp1.period_counter = h_period_counter - 1
2237: and dp1.set_of_books_id = h_set_of_books_id
2238: and dp2.book_type_code = dp1.book_type_code

Line 2297: from fa_mc_deprn_periods

2293:
2294: else
2295:
2296: select fiscal_year into h_cur_fiscal_year
2297: from fa_mc_deprn_periods
2298: where book_type_code = h_book_type_code
2299: and period_counter = h_period_counter
2300: and set_of_books_id = h_set_of_books_id;
2301:

Line 2386: from fa_mc_deprn_periods

2382: else
2383:
2384: select period_Counter,fiscal_year
2385: into h_period_counter,h_amort_fiscal_year
2386: from fa_mc_deprn_periods
2387: where book_type_Code= h_book_type_code
2388: and nvl(calendar_period_open_date,sysdate) <= h_amort_start_date
2389: and nvl(calendar_period_close_date,sysdate) >= h_amort_start_date
2390: and set_of_books_id = h_set_of_books_id;