APPS.IGI_IAC_WEBADI_PKG dependencies on IGI_IAC_REVAL_ASSET_RULES

Line 1205: FROM igi_iac_reval_asset_rules irar,

1201: SELECT irar.asset_id,
1202: fa.asset_number,
1203: irar.selected_for_reval_flag,
1204: iir.status
1205: FROM igi_iac_reval_asset_rules irar,
1206: igi_iac_revaluations iir,
1207: fa_additions fa
1208: WHERE irar.book_type_code = cp_book_type_code
1209: AND fa.asset_id = irar.asset_id

Line 1250: l_current_cost igi_iac_reval_asset_rules.current_cost%TYPE;

1246: AND period_counter = cp_period_counter;
1247:
1248: l_fa_asset_cost fa_books.cost%TYPE;
1249: l_iac_asset_cost igi_iac_asset_balances.adjusted_cost%TYPE;
1250: l_current_cost igi_iac_reval_asset_rules.current_cost%TYPE;
1251: -- bug 3536362, end 1
1252:
1253: l_reval_id Number;
1254: l_reval_date Date;

Line 1264: l_reval_factor igi_iac_reval_asset_rules.revaluation_factor%TYPE;

1260: l_get_period_rec igi_iac_types.prd_rec;
1261: l_create_req_id igi_iac_revaluations.create_request_id%type := null;
1262:
1263: -- bug 3412940, start 1
1264: l_reval_factor igi_iac_reval_asset_rules.revaluation_factor%TYPE;
1265: -- bug 3412940, end 1
1266:
1267: E_Request_Submit_Error exception;
1268: E_Unavailable_Period exception;

Line 1419: Insert into igi_iac_reval_asset_rules(

1415: -- bug 3536362, start 3
1416: l_reval_factor := C_Upload_lines_Rec.new_cost/l_current_cost;
1417: -- bug 3536362, end 3
1418:
1419: Insert into igi_iac_reval_asset_rules(
1420: Revaluation_Id,
1421: Book_Type_Code,
1422: Category_Id,
1423: Asset_Id,