APPS.FA_UTIL_PVT dependencies on FA_BOOK_CONTROLS

Line 2277: fa_book_controls bc

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
2281: AND bks.transaction_header_id_out is null

Line 2395: fa_book_controls bc

2391:
2392: SELECT nvl(ds.system_deprn_amount,0)
2393: INTO l_deprn_amt
2394: FROM fa_deprn_summary ds,
2395: fa_book_controls bc
2396: WHERE bc.book_type_code = X_book
2397: AND ds.book_type_code = bc.book_type_code
2398: AND ds.period_counter = bc.last_period_counter + 1
2399: AND ds.asset_id = X_asset_id

Line 2410: fa_book_controls bc,

2406:
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

Line 2435: fa_book_controls bc

2431: if (h_mc_source_flag = 'Y' and h_mrc_sob_type_code = 'P') then
2432: SELECT nvl(ds.system_deprn_amount, 0)
2433: INTO l_deprn_amt
2434: FROM fa_mc_deprn_summary ds,
2435: fa_book_controls bc
2436: WHERE bc.book_type_code = X_book
2437: AND ds.book_type_code = bc.book_type_code
2438: AND ds.period_counter = bc.last_period_counter + 1
2439: AND ds.asset_id = X_asset_id