APPS.IGI_IMP_IAC_EXCEP_INER_PKG dependencies on FA_CALENDAR_TYPES

Line 82: fa_calendar_types ct

78: FROM
79: fa_system_controls sc,
80: fa_book_controls bc,
81: gl_sets_of_books sob,
82: fa_calendar_types ct
83: WHERE
84: bc.Book_Type_Code = cp_bookType
85: AND sob.Set_Of_Books_ID = BC.Set_Of_Books_ID
86: AND bc.deprn_calendar = ct.calendar_type;

Line 256: CURSOR c_get_periods_in_year(cp_calendar_type fa_calendar_types.calendar_type%TYPE)

252: SELECT deprn_calendar
253: FROM fa_book_controls
254: WHERE book_type_code = cp_book_type_code;
255:
256: CURSOR c_get_periods_in_year(cp_calendar_type fa_calendar_types.calendar_type%TYPE)
257: IS
258: SELECT number_per_fiscal_year
259: FROM fa_calendar_types
260: WHERE calendar_type = cp_calendar_type;

Line 259: FROM fa_calendar_types

255:
256: CURSOR c_get_periods_in_year(cp_calendar_type fa_calendar_types.calendar_type%TYPE)
257: IS
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

Line 269: l_num_per_fiscal_year fa_calendar_types.number_per_fiscal_year%TYPE;

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;
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: