APPS.IGI_IAC_WEBADI_PKG dependencies on IGI_IAC_ASSET_BALANCES

Line 723: From igi_iac_asset_balances

719: cp_book_type_code in igi_iac_upload_headers.book_type_code%type,
720: cp_asset_id in igi_iac_upload_lines.asset_id%type,
721: cp_period_counter in igi_iac_upload_headers.period_counter%type) Is
722: Select nvl(adjusted_cost,0)adjusted_cost
723: From igi_iac_asset_balances
724: Where book_type_code = cp_book_type_code
725: and asset_id = cp_asset_id
726: and period_counter = cp_period_counter;
727:

Line 1243: FROM igi_iac_asset_balances

1239: cp_period_counter IN igi_iac_upload_headers.period_counter%TYPE
1240: )
1241: IS
1242: SELECT nvl(adjusted_cost,0) adjusted_cost
1243: FROM igi_iac_asset_balances
1244: WHERE book_type_code = cp_book_type_code
1245: AND asset_id = cp_asset_id
1246: AND period_counter = cp_period_counter;
1247:

Line 1249: l_iac_asset_cost igi_iac_asset_balances.adjusted_cost%TYPE;

1245: AND asset_id = cp_asset_id
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;