DBA Data[Home] [Help]

APPS.FA_MC_UTIL_PVT dependencies on FA_MC_BOOKS_RATES

Line 193: from fa_mc_books_rates br1

189: select br1.exchange_rate,
190: br1.avg_exchange_rate
191: into px_rate,
192: px_avg_exchange_rate
193: from fa_mc_books_rates br1
194: where br1.asset_id = p_asset_id
195: and br1.book_type_code = p_book_type_code
196: and br1.set_of_books_id = p_set_of_books_id
197: and br1.transaction_header_id =

Line 199: from fa_mc_books_rates br2

195: and br1.book_type_code = p_book_type_code
196: and br1.set_of_books_id = p_set_of_books_id
197: and br1.transaction_header_id =
198: (select max(br2.transaction_header_id)
199: from fa_mc_books_rates br2
200: where br2.asset_id = p_asset_id
201: and br2.book_type_code = p_book_type_code
202: and br2.set_of_books_id = p_set_of_books_id);
203: