eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 = (select max(period_counter)
727: from igi_iac_asset_balances

Line 727: from igi_iac_asset_balances

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 = (select max(period_counter)
727: from igi_iac_asset_balances
728: where book_type_code = cp_book_type_code
729: and asset_id = cp_asset_id); -- Bug 8484461
730:
731: Cursor C_File_Status(

Line 1257: FROM igi_iac_asset_balances

1253: cp_period_counter IN igi_iac_upload_headers.period_counter%TYPE
1254: )
1255: IS
1256: SELECT nvl(adjusted_cost,0) adjusted_cost
1257: FROM igi_iac_asset_balances
1258: WHERE book_type_code = cp_book_type_code
1259: AND asset_id = cp_asset_id
1260: AND period_counter = (SELECT MAX(period_counter)
1261: FROM igi_iac_asset_balances

Line 1261: FROM igi_iac_asset_balances

1257: FROM igi_iac_asset_balances
1258: WHERE book_type_code = cp_book_type_code
1259: AND asset_id = cp_asset_id
1260: AND period_counter = (SELECT MAX(period_counter)
1261: FROM igi_iac_asset_balances
1262: WHERE book_type_code = cp_book_type_code
1263: AND asset_id = cp_asset_id); -- Bug 8484461
1264:
1265: l_fa_asset_cost fa_books.cost%TYPE;

Line 1266: l_iac_asset_cost igi_iac_asset_balances.adjusted_cost%TYPE;

1262: WHERE book_type_code = cp_book_type_code
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;