2864: -- WHERE p_currency_code_name = currency_code || ' - ' || name;
2865:
2866: SELECT currency_code
2867: INTO x_txn_currency_code
2868: FROM fnd_currencies_tl
2869: WHERE name = replace(p_currency_code_name, currency_code || ' - ')
2870: AND language = USERENV('LANG');
2871:
2872: ELSE