APPS.IGI_IAC_PROJ_PKG dependencies on FA_CALENDAR_PERIODS

Line 268: n_start_date fa_calendar_periods.start_date%TYPE,

264:
265: -- To get the price index value for a given period
266: CURSOR c_get_price_index_value(n_book_code fa_books.book_type_code%TYPE,
267: n_category_id fa_category_books.category_id%TYPE,
268: n_start_date fa_calendar_periods.start_date%TYPE,
269: n_end_date fa_calendar_periods.end_date%TYPE,
270: n_calendar_type fa_calendar_periods.calendar_type%TYPE
271: )
272: IS

Line 269: n_end_date fa_calendar_periods.end_date%TYPE,

265: -- To get the price index value for a given period
266: CURSOR c_get_price_index_value(n_book_code fa_books.book_type_code%TYPE,
267: n_category_id fa_category_books.category_id%TYPE,
268: n_start_date fa_calendar_periods.start_date%TYPE,
269: n_end_date fa_calendar_periods.end_date%TYPE,
270: n_calendar_type fa_calendar_periods.calendar_type%TYPE
271: )
272: IS
273: SELECT current_price_index_value

Line 270: n_calendar_type fa_calendar_periods.calendar_type%TYPE

266: CURSOR c_get_price_index_value(n_book_code fa_books.book_type_code%TYPE,
267: n_category_id fa_category_books.category_id%TYPE,
268: n_start_date fa_calendar_periods.start_date%TYPE,
269: n_end_date fa_calendar_periods.end_date%TYPE,
270: n_calendar_type fa_calendar_periods.calendar_type%TYPE
271: )
272: IS
273: SELECT current_price_index_value
274: FROM igi_iac_cal_idx_values

Line 435: l_next_period_num fa_calendar_periods.period_num%TYPE;

431:
432: l_num_per_period fa_calendar_types.number_per_fiscal_year%TYPE;
433: l_mod_value NUMBER;
434: l_fiscal_yr fa_fiscal_year.fiscal_year%TYPE;
435: l_next_period_num fa_calendar_periods.period_num%TYPE;
436: l_calendar fa_calendar_types.calendar_type%TYPE;
437:
438:
439: BEGIN