APPS.IGI_IAC_DEPRN_PKG dependencies on FA_CALENDAR_TYPES

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

284: SELECT deprn_calendar
285: FROM fa_book_controls
286: WHERE book_type_code like p_book_type_code;
287:
288: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
289: SELECT number_per_fiscal_year
290: FROM fa_calendar_types
291: WHERE calendar_type = p_calendar_type;
292: /* Bug 2434532 vgadde 28/06/2002 End(1) */

Line 290: FROM fa_calendar_types

286: WHERE book_type_code like p_book_type_code;
287:
288: CURSOR c_get_periods_in_year(p_calendar_type fa_calendar_types.calendar_type%TYPE) IS
289: SELECT number_per_fiscal_year
290: FROM fa_calendar_types
291: WHERE calendar_type = p_calendar_type;
292: /* Bug 2434532 vgadde 28/06/2002 End(1) */
293:
294: CURSOR c_get_prev_year_inactive_dist(cp_asset_id igi_iac_det_balances.asset_id%TYPE

Line 359: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;

355: l_chart_of_accts_id number(15) ;
356: l_currency_code varchar2(15) ;
357: l_precision varchar2(1) ;
358: l_dpis_period_counter igi_iac_asset_balances.period_counter%TYPE;
359: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
360: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
361: l_total_periods NUMBER;
362: l_last_period_counter NUMBER;
363: l_max_period_counter NUMBER;

Line 360: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;

356: l_currency_code varchar2(15) ;
357: l_precision varchar2(1) ;
358: l_dpis_period_counter igi_iac_asset_balances.period_counter%TYPE;
359: l_deprn_calendar fa_calendar_types.calendar_type%TYPE;
360: l_periods_in_year fa_calendar_types.number_per_fiscal_year%TYPE;
361: l_total_periods NUMBER;
362: l_last_period_counter NUMBER;
363: l_max_period_counter NUMBER;
364: l_fa_transaction_id fa_books.transaction_header_id_in%TYPE;