APPS.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_CAL_IDX_VALUES

Line 253: p_price_index_val OUT NOCOPY igi_iac_cal_idx_values.current_price_index_value%TYPE

249: -- ===================================================================
250: FUNCTION Get_Price_Index_Val(p_book_code fa_books.book_type_code%TYPE,
251: p_category_id fa_category_books.category_id%TYPE,
252: p_period_ctr fa_deprn_periods.period_counter%TYPE,
253: p_price_index_val OUT NOCOPY igi_iac_cal_idx_values.current_price_index_value%TYPE
254: )
255: RETURN BOOLEAN
256: IS
257:

Line 274: FROM igi_iac_cal_idx_values

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
275: WHERE date_from = n_start_date
276: AND date_to = n_end_date
277: AND cal_price_index_link_id = (SELECT cal_price_index_link_id
278: FROM igi_iac_cal_price_indexes

Line 939: l_prior_prd_index_val igi_iac_cal_idx_values.current_price_index_value%TYPE;

935: l_prev_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
936: l_prior_prd_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
937:
938:
939: l_prior_prd_index_val igi_iac_cal_idx_values.current_price_index_value%TYPE;
940: l_curr_price_index_val igi_iac_cal_idx_values.current_price_index_value%TYPE;
941: l_prior_cumul_rate igi_iac_asset_balances.cumulative_reval_factor%TYPE;
942: l_curr_reval_rate igi_iac_asset_balances.current_reval_factor%TYPE;
943: l_curr_reval_rate igi_iac_asset_balances.current_reval_factor%TYPE;

Line 940: l_curr_price_index_val igi_iac_cal_idx_values.current_price_index_value%TYPE;

936: l_prior_prd_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
937:
938:
939: l_prior_prd_index_val igi_iac_cal_idx_values.current_price_index_value%TYPE;
940: l_curr_price_index_val igi_iac_cal_idx_values.current_price_index_value%TYPE;
941: l_prior_cumul_rate igi_iac_asset_balances.cumulative_reval_factor%TYPE;
942: l_curr_reval_rate igi_iac_asset_balances.current_reval_factor%TYPE;
943: l_curr_reval_rate igi_iac_asset_balances.current_reval_factor%TYPE;
944: l_cumul_rate igi_iac_asset_balances.cumulative_reval_factor%TYPE;