DBA Data[Home] [Help]

APPS.FA_CIP_PUB dependencies on FA_MC_BOOKS_RATES

Line 927: from fa_mc_books_rates br1

923: px_asset_fin_rec.cost;
924: else
925: select br1.avg_exchange_rate
926: into l_avg_rate
927: from fa_mc_books_rates br1
928: where br1.asset_id = l_asset_hdr_rec.asset_id
929: and br1.book_type_code = l_asset_hdr_rec.book_type_code
930: and br1.set_of_books_id = l_asset_hdr_rec.set_of_books_id
931: and br1.transaction_header_id =

Line 933: from fa_mc_books_rates br2

929: and br1.book_type_code = l_asset_hdr_rec.book_type_code
930: and br1.set_of_books_id = l_asset_hdr_rec.set_of_books_id
931: and br1.transaction_header_id =
932: (select max(br2.transaction_header_id)
933: from fa_mc_books_rates br2
934: where br2.asset_id = l_asset_hdr_rec.asset_id
935: and br2.book_type_code = l_asset_hdr_rec.book_type_code
936: and br2.set_of_books_id = l_asset_hdr_rec.set_of_books_id);
937: end if;