DBA Data[Home] [Help]

APPS.FA_UNPLANNED_PUB dependencies on FA_MC_BOOKS_RATES

Line 618: from fa_mc_books_rates

614:
615: -- get the current average exchange rate to convert the unplanned amount
616: select avg_exchange_rate
617: into l_avg_rate
618: from fa_mc_books_rates
619: where asset_id = l_asset_hdr_rec.asset_id
620: and book_type_code = l_asset_hdr_rec.book_type_code
621: and set_of_books_id = l_asset_hdr_rec.set_of_books_id
622: and transaction_header_id =

Line 624: from fa_mc_books_rates

620: and book_type_code = l_asset_hdr_rec.book_type_code
621: and set_of_books_id = l_asset_hdr_rec.set_of_books_id
622: and transaction_header_id =
623: (select max(transaction_header_id)
624: from fa_mc_books_rates
625: where asset_id = l_asset_hdr_rec.asset_id
626: and book_type_code = l_asset_hdr_rec.book_type_code
627: and set_of_books_id = l_asset_hdr_rec.set_of_books_id);
628: