APPS.FA_UTIL_PVT dependencies on FA_BOOKS

Line 7: p_transaction_header_id IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE DEFAULT NULL,

3:
4: FUNCTION get_asset_fin_rec
5: (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7: p_transaction_header_id IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE DEFAULT NULL,
8: p_mrc_sob_type_code IN VARCHAR2
9: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
10: ) RETURN BOOLEAN IS
11:

Line 473: from fa_books

469: px_asset_fin_rec.prior_life_in_months ,
470: px_asset_fin_rec.prior_basic_rate ,
471: px_asset_fin_rec.prior_adjusted_rate , -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
472: px_asset_fin_rec.rate_in_use --phase5
473: from fa_books
474: where asset_id = p_asset_hdr_rec.asset_id
475: and book_type_code = p_asset_hdr_rec.book_type_code
476: and transaction_header_id_out is null;
477:

Line 936: from fa_books

932: px_asset_fin_rec.prior_life_in_months ,
933: px_asset_fin_rec.prior_basic_rate ,
934: px_asset_fin_rec.prior_adjusted_rate , -- Changes made as per the ER No.s 6606548 and 6606552 by Sbyreddy End
935: px_asset_fin_rec.rate_in_use --phase5
936: from fa_books
937: where asset_id = p_asset_hdr_rec.asset_id
938: and book_type_code = p_asset_hdr_rec.book_type_code
939: and transaction_header_id_in = p_transaction_header_id;
940:

Line 2276: FROM fa_books bks,

2272: BEGIN
2273:
2274: SELECT bc.book_type_code
2275: INTO p_corp_book
2276: FROM fa_books bks,
2277: fa_book_controls bc
2278: WHERE bks.book_type_code = bc.distribution_source_book
2279: AND bks.book_type_code = bc.book_type_code
2280: AND bks.asset_id = p_asset_id

Line 2294: value2 => 'FA_BOOKS'

2290: name => 'FA_SHARED_ACTION_TABLE',
2291: token1 => 'ACTION',
2292: value1 => 'SELECT',
2293: token2 => 'TABLE',
2294: value2 => 'FA_BOOKS'
2295: , p_log_level_rec => p_log_level_rec);
2296: return FALSE;
2297:
2298: END get_corp_book;

Line 2411: fa_books bks,

2407: select nvl(ds.system_deprn_amount,0)
2408: into l_deprn_amt
2409: FROM fa_deprn_summary ds,
2410: fa_book_controls bc,
2411: fa_books bks,
2412: fa_additions_b ad
2413: WHERE bc.book_type_code = X_Book
2414: AND ds.book_type_code = bc.book_type_code
2415: AND ds.period_counter = bc.last_period_counter + 1