DBA Data[Home] [Help]

VIEW: APPS.HRI_CONVERT_FROM_CURRENCIES_V

Source

View Text - Preformatted

SELECT distinct input_currency_code CURRENCY from pay_element_types_f minus select null from dual union all select 'NA_EDW' AS CURRENCY from dual WHERE 1=1 WITH READ ONLY
View Text - HTML Formatted

SELECT DISTINCT INPUT_CURRENCY_CODE CURRENCY
FROM PAY_ELEMENT_TYPES_F MINUS SELECT NULL
FROM DUAL UNION ALL SELECT 'NA_EDW' AS CURRENCY
FROM DUAL
WHERE 1=1 WITH READ ONLY