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_ADDITIONS_PKG dependencies on FA_BOOKS

Line 320: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS

316: AND ith.asset_id = p_asset_id
317: AND (ith.transaction_type_code = 'ADDITION' AND ith.Transaction_sub_type ='REVALUATION');
318:
319: /* Cursor to get cost and salvage value for the asset from FA */
320: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
321: SELECT salvage_value,cost
322: FROM fa_books
323: WHERE book_type_code = p_book_type_code
324: AND asset_id = p_asset_id

Line 322: FROM fa_books

318:
319: /* Cursor to get cost and salvage value for the asset from FA */
320: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
321: SELECT salvage_value,cost
322: FROM fa_books
323: WHERE book_type_code = p_book_type_code
324: AND asset_id = p_asset_id
325: AND transactioN_header_id_out is NULL ;
326:

Line 599: OPEN c_fa_books(p_asset_id);

595: /*Salavge value correction*/
596: -- resreve
597: IF (p_salvage_value Is Null) Or (P_cost is Null) THEN
598:
599: OPEN c_fa_books(p_asset_id);
600: FETCH c_fa_books into l_salvage_value,
601: l_cost;
602: CLOSE c_fa_books;
603: ELSE

Line 600: FETCH c_fa_books into l_salvage_value,

596: -- resreve
597: IF (p_salvage_value Is Null) Or (P_cost is Null) THEN
598:
599: OPEN c_fa_books(p_asset_id);
600: FETCH c_fa_books into l_salvage_value,
601: l_cost;
602: CLOSE c_fa_books;
603: ELSE
604: l_salvage_value := p_salvage_value;

Line 602: CLOSE c_fa_books;

598:
599: OPEN c_fa_books(p_asset_id);
600: FETCH c_fa_books into l_salvage_value,
601: l_cost;
602: CLOSE c_fa_books;
603: ELSE
604: l_salvage_value := p_salvage_value;
605: l_cost := P_cost;
606: END IF;