APPS.IGI_IMP_IAC_EXCEP_INER_PKG dependencies on IGI_IAC_BOOK_CONTROLS

Line 262: CURSOR c_get_reval_period(cp_book_type_code igi_iac_book_controls.book_type_code%TYPE)

258: SELECT number_per_fiscal_year
259: FROM fa_calendar_types
260: WHERE calendar_type = cp_calendar_type;
261:
262: CURSOR c_get_reval_period(cp_book_type_code igi_iac_book_controls.book_type_code%TYPE)
263: IS
264: SELECT period_num_for_catchup
265: FROM igi_iac_book_controls
266: WHERE book_type_code = cp_book_type_code;

Line 265: FROM igi_iac_book_controls

261:
262: CURSOR c_get_reval_period(cp_book_type_code igi_iac_book_controls.book_type_code%TYPE)
263: IS
264: SELECT period_num_for_catchup
265: FROM igi_iac_book_controls
266: WHERE book_type_code = cp_book_type_code;
267:
268: l_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
269: l_num_per_fiscal_year fa_calendar_types.number_per_fiscal_year%TYPE;

Line 270: l_iac_reval_period_num igi_iac_book_controls.period_num_for_catchup%TYPE;

266: WHERE book_type_code = cp_book_type_code;
267:
268: l_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
269: l_num_per_fiscal_year fa_calendar_types.number_per_fiscal_year%TYPE;
270: l_iac_reval_period_num igi_iac_book_controls.period_num_for_catchup%TYPE;
271:
272: l_curr_period igi_iac_types.prd_rec;
273:
274: l_curr_period_num igi_iac_book_controls.period_num_for_catchup%TYPE;

Line 274: l_curr_period_num igi_iac_book_controls.period_num_for_catchup%TYPE;

270: l_iac_reval_period_num igi_iac_book_controls.period_num_for_catchup%TYPE;
271:
272: l_curr_period igi_iac_types.prd_rec;
273:
274: l_curr_period_num igi_iac_book_controls.period_num_for_catchup%TYPE;
275: l_curr_fiscal_year fa_deprn_periods.fiscal_year%TYPE;
276: l_curr_prd_counter fa_deprn_periods.period_counter%TYPE;
277: l_reval_prd_counter fa_deprn_periods.period_counter%TYPE;
278: