DBA Data[Home] [Help]

APPS.IGI_IAC_PROJ_PKG dependencies on IGI_IAC_ASSET_BALANCES

Line 714: FROM igi_iac_asset_balances

710: WHERE book_type_code = n_book_type_code
711: AND period_close_date IS NULL)
712: AND bk.asset_id NOT IN
713: (SELECT asset_id
714: FROM igi_iac_asset_balances
715: WHERE book_type_code = bk.book_type_code
716: AND asset_id = bk.asset_id)
717: AND bk.depreciate_flag <> 'NO'
718: GROUP BY ad.asset_id,

Line 923: l_iac_cost igi_iac_asset_balances.adjusted_cost%TYPE;

919: l_company_seg VARCHAR2(30);
920: l_cc_seg VARCHAR2(30);
921:
922: l_hist_cost fa_books.cost%TYPE;
923: l_iac_cost igi_iac_asset_balances.adjusted_cost%TYPE;
924: l_hist_deprn_period igi_iac_proj_details.deprn_period%TYPE;
925: l_iac_deprn_period igi_iac_proj_details.deprn_period%TYPE;
926: l_hist_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;
927: l_iac_deprn_ytd igi_iac_proj_details.deprn_ytd%TYPE;

Line 941: l_prior_cumul_rate igi_iac_asset_balances.cumulative_reval_factor%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;
945:

Line 942: l_curr_reval_rate igi_iac_asset_balances.current_reval_factor%TYPE;

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;
945:
946: l_count NUMBER := 1;

Line 943: l_curr_reval_rate igi_iac_asset_balances.current_reval_factor%TYPE;

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;
945:
946: l_count NUMBER := 1;
947: l_login_id NUMBER := fnd_profile.value('LOGIN_ID');

Line 944: l_cumul_rate igi_iac_asset_balances.cumulative_reval_factor%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;
945:
946: l_count NUMBER := 1;
947: l_login_id NUMBER := fnd_profile.value('LOGIN_ID');
948: l_user_id NUMBER := fnd_profile.value('USER_ID');