APPS.IGI_IAC_CREATE_ASSETS dependencies on FA_BOOKS

Line 39: FROM fa_books

35: p_asset_id IN NUMBER)
36: IS
37:
38: SELECT 'X'
39: FROM fa_books
40: WHERE book_type_code = p_book
41: AND asset_id = p_asset_id
42: AND period_counter_fully_reserved IS NOT NULL;
43:

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

202:
203: TYPE asset_id_tbl_type IS TABLE OF FA_ADDITIONS.ASSET_ID%TYPE
204: INDEX BY BINARY_INTEGER;
205:
206: TYPE cost_tbl_type IS TABLE OF FA_BOOKS.COST%TYPE
207: INDEX BY BINARY_INTEGER;
208:
209: l_asset_id asset_id_tbl_type;
210: l_cost_tbl cost_tbl_type;

Line 239: fa_books b

235: ) IS
236: SELECT a.asset_id,
237: b.cost
238: FROM fa_additions a,
239: fa_books b
240: WHERE a.asset_id = b.asset_id
241: AND b.book_type_code = p_book_type_code
242: AND a.asset_category_id = p_cat_id
243: AND a.asset_type <> 'CIP' -- bug 3416315

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

275: WHERE asset_id = p_asset_id
276: AND latest_record = 'Y'
277: AND book_type_code = p_book_type_code;
278:
279: CURSOR c_get_date_place_in_service(p_asset_id IN fa_books.asset_id%TYPE) IS
280: SELECT date_placed_in_service
281: FROM fa_books
282: WHERE asset_id = p_asset_id
283: AND book_type_code = p_book_type_code

Line 281: FROM fa_books

277: AND book_type_code = p_book_type_code;
278:
279: CURSOR c_get_date_place_in_service(p_asset_id IN fa_books.asset_id%TYPE) IS
280: SELECT date_placed_in_service
281: FROM fa_books
282: WHERE asset_id = p_asset_id
283: AND book_type_code = p_book_type_code
284: AND date_ineffective IS NULL;
285: