APPS.IGI_IMP_IAC_PREPARE_PKG dependencies on FA_DEPRN_PERIODS

Line 37: From fa_deprn_periods dp

33: and ad.asset_category_id = p_category_id;
34:
35: Cursor C_Fiscal_Year(p_book in varchar2, p_period_counter in number) Is
36: Select fiscal_year
37: From fa_deprn_periods dp
38: Where book_type_code = p_book
39: and period_counter = p_period_counter;
40:
41: Cursor C_Corp_Book_Info(p_book in varchar2, p_asset_id in number) Is

Line 415: fa_deprn_periods dp1,

411: dp2.fiscal_year corp_per_fiscal_year,
412: dp2.period_num corp_curr_period_num
413: From igi_imp_iac_controls ict,
414: fa_book_controls bk,
415: fa_deprn_periods dp1,
416: fa_deprn_periods dp2
417: Where ict.book_type_code = p_book_type_code
418: and bk.book_type_code = ict.book_type_code
419: and dp1.book_type_code = ict.book_type_code

Line 416: fa_deprn_periods dp2

412: dp2.period_num corp_curr_period_num
413: From igi_imp_iac_controls ict,
414: fa_book_controls bk,
415: fa_deprn_periods dp1,
416: fa_deprn_periods dp2
417: Where ict.book_type_code = p_book_type_code
418: and bk.book_type_code = ict.book_type_code
419: and dp1.book_type_code = ict.book_type_code
420: and dp1.period_counter = bk.last_period_counter + 1