APPS.IGI_IAC_DEPRN_PKG dependencies on FA_CALENDAR_PERIODS

Line 36: FROM fa_calendar_periods

32:
33: /* Cursor for getting the last calendar period from Oracle Assets */
34: CURSOR c_fa_max_date(p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS
35: SELECT max(end_date)
36: FROM fa_calendar_periods
37: WHERE calendar_type = (
38: SELECT calendar_type
39: FROM igi_iac_cal_price_indexes
40: WHERE cal_price_index_link_id = p_cal_price_index_link_id );

Line 60: FROM fa_calendar_periods

56: /* Cursor to get all periods from FA which are greater than the last period defined in IAC */
57: CURSOR c_get_fa_periods(p_max_date_to date ,
58: p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS
59: SELECT start_date, end_date
60: FROM fa_calendar_periods
61: WHERE trunc(end_date) > trunc(p_max_date_to)
62: AND calendar_type = (
63: SELECT calendar_type
64: FROM igi_iac_cal_price_indexes