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