EBS find the method of exchange rate conversion between the standard currency and currency of the account set

(1) To obtain a set of standard currency

--Get current account set standard currency
SELECT Gsob.currency_code
From Gl_sets_of_books GSob,
Hr_operating_units Hou
WHERE gsob.set_of_books_id = hou.set_of_books_id
and hou.organization_id = Fnd_profile.value (' org_id ');
(2) conversion between currency types

--The exchange rate for the day that the specified currency (for example, HKD) is diverted to the current set of currency (for example: CNY)
SELECT gdr.conversion_rate
From Gl_daily_rates_v GDR
WHERE gdr.from_currency = ' HKD '
and Gdr.to_currency in (SELECT Gsob.currency_code
From Gl_sets_of_books GSob,
Hr_operating_units Hou
WHERE gsob.set_of_books_id = hou.set_of_books_id
and hou.organization_id = Fnd_profile.value (' org_id '))
and Gdr.conversion_type = ' Corporate '
and gdr.conversion_date = Trunc (sysdate);
(3) Call the EBS API to convert

SELECT gl_currency_api.get_rate (x_from_currency = ' HKD ',
x_to_currency = ' CNY ',
X_conversion_date = Trunc (sysdate),
X_conversion_type = ' Corporate ')
If the two currencies you want to convert are the same, make a decision at the time of the query, and then take the value 1.

EBS find the method of exchange rate conversion between the standard currency and currency of the account set