APPS.IGI_IMP_IAC_EXCEP_INER_PKG dependencies on FA_DEPRN_PERIODS

Line 40: FROM fa_deprn_periods

36: RETURN BOOLEAN IS
37:
38: CURSOR c_period (cp_bookType VARCHAR2, cp_period VARCHAR2) IS
39: SELECT period_name
40: FROM fa_deprn_periods
41: WHERE Book_Type_Code = cp_bookType
42: AND period_counter = TO_NUMBER(cp_period);
43:
44: l_selOk BOOLEAN := FALSE;

Line 275: l_curr_fiscal_year fa_deprn_periods.fiscal_year%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:
279: l_dpis_period igi_iac_types.prd_rec;

Line 276: l_curr_prd_counter fa_deprn_periods.period_counter%TYPE;

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:
279: l_dpis_period igi_iac_types.prd_rec;
280: l_dpis_prd_counter fa_deprn_periods.period_counter%TYPE;

Line 277: l_reval_prd_counter fa_deprn_periods.period_counter%TYPE;

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:
279: l_dpis_period igi_iac_types.prd_rec;
280: l_dpis_prd_counter fa_deprn_periods.period_counter%TYPE;
281: l_ret BOOLEAN;

Line 280: l_dpis_prd_counter fa_deprn_periods.period_counter%TYPE;

276: l_curr_prd_counter fa_deprn_periods.period_counter%TYPE;
277: l_reval_prd_counter fa_deprn_periods.period_counter%TYPE;
278:
279: l_dpis_period igi_iac_types.prd_rec;
280: l_dpis_prd_counter fa_deprn_periods.period_counter%TYPE;
281: l_ret BOOLEAN;
282: -- bug 3442275, end 1
283:
284: l_initial_flag varchar2(1) :='N';