APPS.IGI_IAC_YTD_ENGINE dependencies on FA_CALENDAR_TYPES

Line 33: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS

29: SELECT deprn_calendar
30: FROM fa_book_controls
31: WHERE book_type_code like p_book_type_code;
32:
33: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
34: SELECT number_per_fiscal_year
35: FROM fa_calendar_types
36: WHERE calendar_type = p_calendar_type;
37:

Line 35: FROM fa_calendar_types

31: WHERE book_type_code like p_book_type_code;
32:
33: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
34: SELECT number_per_fiscal_year
35: FROM fa_calendar_types
36: WHERE calendar_type = p_calendar_type;
37:
38: l_start_period igi_iac_types.prd_rec;
39: l_end_period igi_iac_types.prd_rec;

Line 46: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;

42: l_last_period igi_iac_types.prd_rec;
43: l_deprn_reserve NUMBER;
44: l_max_deprn_period NUMBER(15);
45: l_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
46: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
47: l_total_periods NUMBER;
48: l_last_period_counter NUMBER;
49: l_last_deprn_period igi_iac_types.prd_rec;
50: l_deprn_periods_elapsed NUMBER;