APPS.IGI_IAC_CREATE_ASSETS dependencies on FA_BOOKS

Line 62: FROM fa_books

58: p_asset_id IN NUMBER)
59: IS
60:
61: SELECT 'X'
62: FROM fa_books
63: WHERE book_type_code = p_book
64: AND asset_id = p_asset_id
65: AND period_counter_fully_reserved IS NOT NULL;
66:

Line 229: TYPE cost_tbl_type IS TABLE OF FA_BOOKS.COST%TYPE

225:
226: TYPE asset_id_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_ID%TYPE
227: INDEX BY BINARY_INTEGER;
228:
229: TYPE cost_tbl_type IS TABLE OF FA_BOOKS.COST%TYPE
230: INDEX BY BINARY_INTEGER;
231:
232: l_asset_id asset_id_tbl_type;
233: l_cost_tbl cost_tbl_type;

Line 262: fa_books b

258: ) IS
259: SELECT a.asset_id,
260: b.cost
261: FROM fa_additions a,
262: fa_books b
263: WHERE a.asset_id = b.asset_id
264: AND b.book_type_code = p_book_type_code
265: AND a.asset_category_id = p_cat_id
266: AND a.asset_type <> 'CIP' -- bug 3416315

Line 302: CURSOR c_get_date_place_in_service(p_asset_id IN fa_books.asset_id%TYPE) IS

298: WHERE asset_id = p_asset_id
299: AND latest_record = 'Y'
300: AND book_type_code = p_book_type_code;
301:
302: CURSOR c_get_date_place_in_service(p_asset_id IN fa_books.asset_id%TYPE) IS
303: SELECT date_placed_in_service
304: FROM fa_books
305: WHERE asset_id = p_asset_id
306: AND book_type_code = p_book_type_code

Line 304: FROM fa_books

300: AND book_type_code = p_book_type_code;
301:
302: CURSOR c_get_date_place_in_service(p_asset_id IN fa_books.asset_id%TYPE) IS
303: SELECT date_placed_in_service
304: FROM fa_books
305: WHERE asset_id = p_asset_id
306: AND book_type_code = p_book_type_code
307: AND date_ineffective IS NULL;
308: