DBA Data[Home] [Help]

APPS.FA_MC_UTIL_PVT dependencies on FA_MC_BOOKS_RATES

Line 58: FROM fa_mc_books_rates

54: end if;
55:
56: select count(1)
57: into l_found_in_corp
58: FROM fa_mc_books_rates
59: WHERE set_of_books_id = p_set_of_books_id
60: AND transaction_header_id = p_transaction_header_id;
61:
62: if l_found_in_corp = 0 then

Line 254: from fa_mc_books_rates br1

250: select br1.exchange_rate,
251: br1.avg_exchange_rate
252: into px_rate,
253: px_avg_exchange_rate
254: from fa_mc_books_rates br1
255: where br1.asset_id = p_asset_id
256: and br1.book_type_code = p_book_type_code
257: and br1.set_of_books_id = p_set_of_books_id
258: and br1.transaction_header_id =

Line 260: from fa_mc_books_rates br2

256: and br1.book_type_code = p_book_type_code
257: and br1.set_of_books_id = p_set_of_books_id
258: and br1.transaction_header_id =
259: (select max(br2.transaction_header_id)
260: from fa_mc_books_rates br2
261: where br2.asset_id = p_asset_id
262: and br2.book_type_code = p_book_type_code
263: and br2.set_of_books_id = p_set_of_books_id);
264: