DBA Data[Home] [Help]

APPS.FA_CIP_PUB dependencies on FA_MC_BOOKS_RATES

Line 956: from fa_mc_books_rates br1

952: px_asset_fin_rec.cost;
953: else
954: select br1.avg_exchange_rate
955: into l_avg_rate
956: from fa_mc_books_rates br1
957: where br1.asset_id = l_asset_hdr_rec.asset_id
958: and br1.book_type_code = l_asset_hdr_rec.book_type_code
959: and br1.set_of_books_id = l_asset_hdr_rec.set_of_books_id
960: and br1.transaction_header_id =

Line 962: from fa_mc_books_rates br2

958: and br1.book_type_code = l_asset_hdr_rec.book_type_code
959: and br1.set_of_books_id = l_asset_hdr_rec.set_of_books_id
960: and br1.transaction_header_id =
961: (select max(br2.transaction_header_id)
962: from fa_mc_books_rates br2
963: where br2.asset_id = l_asset_hdr_rec.asset_id
964: and br2.book_type_code = l_asset_hdr_rec.book_type_code
965: and br2.set_of_books_id = l_asset_hdr_rec.set_of_books_id);
966: end if;