APPS.IGI_IAC_DEPRN_PKG dependencies on IGI_IAC_CAL_PRICE_INDEXES

Line 34: CURSOR c_fa_max_date(p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS

30: FROM igi_iac_category_books
31: WHERE book_type_code = p_book_type_code;
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

Line 39: FROM igi_iac_cal_price_indexes

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 );
41:
42: /* Cursor for getting the last period from Inflation Accounting */
43: CURSOR c_iac_max_date(p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS

Line 43: CURSOR c_iac_max_date(p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS

39: FROM igi_iac_cal_price_indexes
40: WHERE cal_price_index_link_id = p_cal_price_index_link_id );
41:
42: /* Cursor for getting the last period from Inflation Accounting */
43: CURSOR c_iac_max_date(p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS
44: SELECT max(date_to)
45: FROM igi_iac_cal_idx_values
46: WHERE cal_price_index_link_id = p_cal_price_index_link_id;
47:

Line 50: p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS

46: WHERE cal_price_index_link_id = p_cal_price_index_link_id;
47:
48: /* Cursor for getting the Price Index value defined for the last period defined in IAC */
49: CURSOR c_current_price_index(p_max_date_to date ,
50: p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS
51: SELECT current_price_index_value
52: FROM igi_iac_cal_idx_values
53: WHERE trunc(date_to) = trunc(p_max_date_to)
54: AND cal_price_index_link_id = p_cal_price_index_link_id ;

Line 58: p_cal_price_index_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%TYPE) IS

54: AND cal_price_index_link_id = p_cal_price_index_link_id ;
55:
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 = (

Line 64: FROM igi_iac_cal_price_indexes

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
65: WHERE cal_price_index_link_id = p_cal_price_index_link_id );
66:
67: l_fa_max_date date;
68: l_iac_max_date date;