DBA Data[Home] [Help]

APPS.FA_UTIL_PVT dependencies on FA_BOOK_CONTROLS

Line 2219: fa_book_controls bc

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

Line 2345: fa_book_controls bc

2341:
2342: SELECT ds.deprn_amount
2343: INTO l_deprn_amt
2344: FROM fa_deprn_summary ds,
2345: fa_book_controls bc
2346: WHERE bc.book_type_code = X_book
2347: AND ds.book_type_code = bc.book_type_code
2348: AND ds.period_counter = bc.last_period_counter + 1
2349: AND ds.asset_id = X_asset_id

Line 2360: fa_book_controls bc,

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

Line 2385: fa_book_controls bc

2381: if (h_mc_source_flag = 'Y' and h_mrc_sob_type_code = 'P') then
2382: SELECT ds.deprn_amount
2383: INTO l_deprn_amt
2384: FROM fa_mc_deprn_summary ds,
2385: fa_book_controls bc
2386: WHERE bc.book_type_code = X_book
2387: AND ds.book_type_code = bc.book_type_code
2388: AND ds.period_counter = bc.last_period_counter + 1
2389: AND ds.asset_id = X_asset_id