APPS.IGI_IAC_WEBADI_PKG dependencies on IGI_IAC_REVAL_ASSET_RULES

Line 1219: FROM igi_iac_reval_asset_rules irar,

1215: SELECT irar.asset_id,
1216: fa.asset_number,
1217: irar.selected_for_reval_flag,
1218: iir.status
1219: FROM igi_iac_reval_asset_rules irar,
1220: igi_iac_revaluations iir,
1221: fa_additions fa
1222: WHERE irar.book_type_code = cp_book_type_code
1223: AND fa.asset_id = irar.asset_id

Line 1267: l_current_cost igi_iac_reval_asset_rules.current_cost%TYPE;

1263: AND asset_id = cp_asset_id); -- Bug 8484461
1264:
1265: l_fa_asset_cost fa_books.cost%TYPE;
1266: l_iac_asset_cost igi_iac_asset_balances.adjusted_cost%TYPE;
1267: l_current_cost igi_iac_reval_asset_rules.current_cost%TYPE;
1268: -- bug 3536362, end 1
1269:
1270: l_reval_id Number;
1271: l_reval_date Date;

Line 1281: l_reval_factor igi_iac_reval_asset_rules.revaluation_factor%TYPE;

1277: l_get_period_rec igi_iac_types.prd_rec;
1278: l_create_req_id igi_iac_revaluations.create_request_id%type := null;
1279:
1280: -- bug 3412940, start 1
1281: l_reval_factor igi_iac_reval_asset_rules.revaluation_factor%TYPE;
1282: -- bug 3412940, end 1
1283:
1284: E_Request_Submit_Error exception;
1285: E_Unavailable_Period exception;

Line 1437: Insert into igi_iac_reval_asset_rules(

1433: -- bug 3536362, start 3
1434: l_reval_factor := C_Upload_lines_Rec.new_cost/l_current_cost;
1435: -- bug 3536362, end 3
1436:
1437: Insert into igi_iac_reval_asset_rules(
1438: Revaluation_Id,
1439: Book_Type_Code,
1440: Category_Id,
1441: Asset_Id,