APPS.IGI_IAC_REBASE_PKG dependencies on FA_CALENDAR_PERIODS

Line 51: p_period fa_calendar_periods.period_name%type) is

47: /* Cursor to obtain current price index value for the rebasing period */
48:
49: Cursor c_get_rebase_period(p_link_id igi_iac_cal_idx_values.cal_price_index_link_id%type,
50: p_calendar igi_iac_cal_price_indexes.calendar_type%type,
51: p_period fa_calendar_periods.period_name%type) is
52: Select iciv.current_price_index_value from
53: igi_iac_cal_idx_values iciv ,fa_calendar_periods fcp
54: where fcp.start_date = iciv.date_from and
55: fcp.end_date = iciv.date_to and

Line 53: igi_iac_cal_idx_values iciv ,fa_calendar_periods fcp

49: Cursor c_get_rebase_period(p_link_id igi_iac_cal_idx_values.cal_price_index_link_id%type,
50: p_calendar igi_iac_cal_price_indexes.calendar_type%type,
51: p_period fa_calendar_periods.period_name%type) is
52: Select iciv.current_price_index_value from
53: igi_iac_cal_idx_values iciv ,fa_calendar_periods fcp
54: where fcp.start_date = iciv.date_from and
55: fcp.end_date = iciv.date_to and
56: fcp.calendar_type = p_calendar and
57: fcp.period_name = p_period and

Line 60: /* Select iciv.current_price_index_value from igi_iac_cal_idx_values iciv , fa_calendar_periods fcp where

56: fcp.calendar_type = p_calendar and
57: fcp.period_name = p_period and
58: iciv.cal_price_index_link_id = p_link_id;
59:
60: /* Select iciv.current_price_index_value from igi_iac_cal_idx_values iciv , fa_calendar_periods fcp where
61: fcp.calendar_type = calendar and
62: fcp.period_name = period_name and
63: iciv.date_from = fcp.start_date and
64: iciv.date_to = fcp.end_date and

Line 77: Select fap.period_name from fa_calendar_periods fap

73:
74: /* Cursor to get the period name - for display in the log file only */
75: Cursor c_get_period_name(l_date_from igi_iac_cal_idx_values.date_from%type,
76: l_date_to igi_iac_cal_idx_values.date_to%type) is
77: Select fap.period_name from fa_calendar_periods fap
78: where start_date =l_date_from and end_date = l_date_to and
79: calendar_type= calendar;
80:
81: /* Cursor to get the precision */

Line 91: l_period fa_calendar_periods.period_name%type;

87:
88: l_link_id igi_iac_cal_price_indexes.cal_price_index_link_id%type;
89: l_price_index_id igi_iac_price_indexes.price_index_id%type;
90: l_calendar igi_iac_cal_price_indexes.calendar_type%type;
91: l_period fa_calendar_periods.period_name%type;
92: l_default_index_val igi_iac_cal_idx_values.current_price_index_value%type default 9999.99;
93:
94:
95: