APPS.IGI_IAC_YTD_ENGINE dependencies on FA_CALENDAR_TYPES

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

65: SELECT deprn_calendar
66: FROM fa_book_controls
67: WHERE book_type_code like p_book_type_code;
68:
69: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
70: SELECT number_per_fiscal_year
71: FROM fa_calendar_types
72: WHERE calendar_type = p_calendar_type;
73:

Line 71: FROM fa_calendar_types

67: WHERE book_type_code like p_book_type_code;
68:
69: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
70: SELECT number_per_fiscal_year
71: FROM fa_calendar_types
72: WHERE calendar_type = p_calendar_type;
73:
74: l_start_period igi_iac_types.prd_rec;
75: l_end_period igi_iac_types.prd_rec;

Line 82: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;

78: l_last_period igi_iac_types.prd_rec;
79: l_deprn_reserve NUMBER;
80: l_max_deprn_period NUMBER(15);
81: l_deprn_calendar fa_book_controls.deprn_calendar%TYPE;
82: l_periods_per_FY fa_calendar_types.number_per_fiscal_year%TYPE;
83: l_total_periods NUMBER;
84: l_last_period_counter NUMBER;
85: l_last_deprn_period igi_iac_types.prd_rec;
86: l_deprn_periods_elapsed NUMBER;