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) RETURN BOOLEAN IS
10:
11: error_found EXCEPTION;

Line 226: from fa_books_mrc_v

222: px_asset_fin_rec.ltd_cost_of_removal ,
223: px_asset_fin_rec.exclude_proceeds_from_basis ,
224: px_asset_fin_rec.retirement_deprn_option ,
225: px_asset_fin_rec.contract_id -- Bug:6021567
226: from fa_books_mrc_v
227: where asset_id = p_asset_hdr_rec.asset_id
228: and book_type_code = p_asset_hdr_rec.book_type_code
229: and transaction_header_id_out is null;
230:

Line 446: from fa_books

442: px_asset_fin_rec.contract_id , -- Bug:6021567
443: px_asset_fin_rec.extended_deprn_flag , -- Japan Tax phase3
444: px_asset_fin_rec.extended_depreciation_period , -- Japan Tax phase3
445: px_asset_fin_rec.period_counter_fully_extended -- Japan Tax phase3
446: from fa_books
447: where asset_id = p_asset_hdr_rec.asset_id
448: and book_type_code = p_asset_hdr_rec.book_type_code
449: and transaction_header_id_out is null;
450:

Line 664: from fa_books_mrc_v

660: px_asset_fin_rec.ltd_cost_of_removal ,
661: px_asset_fin_rec.exclude_proceeds_from_basis ,
662: px_asset_fin_rec.retirement_deprn_option ,
663: px_asset_fin_rec.contract_id -- Bug:6021567
664: from fa_books_mrc_v
665: where asset_id = p_asset_hdr_rec.asset_id
666: and book_type_code = p_asset_hdr_rec.book_type_code
667: and transaction_header_id_in = p_transaction_header_id;
668: else

Line 883: from fa_books

879: px_asset_fin_rec.contract_id , -- Bug:6021567
880: px_asset_fin_rec.extended_deprn_flag , -- Japan Tax phase3
881: px_asset_fin_rec.extended_depreciation_period , -- Japan Tax phase3
882: px_asset_fin_rec.period_counter_fully_extended -- Japan Tax phase3
883: from fa_books
884: where asset_id = p_asset_hdr_rec.asset_id
885: and book_type_code = p_asset_hdr_rec.book_type_code
886: and transaction_header_id_in = p_transaction_header_id;
887:

Line 2218: FROM fa_books bks,

2214: BEGIN
2215:
2216: SELECT bc.book_type_code
2217: INTO p_corp_book
2218: FROM fa_books bks,
2219: fa_book_controls bc
2220: WHERE bks.book_type_code = bc.distribution_source_book
2221: AND bks.book_type_code = bc.book_type_code
2222: AND bks.asset_id = p_asset_id

Line 2236: value2 => 'FA_BOOKS'

2232: name => 'FA_SHARED_ACTION_TABLE',
2233: token1 => 'ACTION',
2234: value1 => 'SELECT',
2235: token2 => 'TABLE',
2236: value2 => 'FA_BOOKS'
2237: ,p_log_level_rec => p_log_level_rec);
2238: return FALSE;
2239:
2240: END get_corp_book;

Line 2361: fa_books bks,

2357: select ds.deprn_amount
2358: into l_deprn_amt
2359: FROM fa_deprn_summary ds,
2360: fa_book_controls bc,
2361: fa_books bks,
2362: fa_additions_b ad
2363: WHERE bc.book_type_code = X_Book
2364: AND ds.book_type_code = bc.book_type_code
2365: AND ds.period_counter = bc.last_period_counter + 1