DBA Data[Home] [Help]

VIEW: APPS.PER_RI_CONFIG_COUNTRY_V

Source

View Text - Preformatted

SELECT CONFIGURATION_CODE configuration_code, CONFIG_INFORMATION_ID config_information_id, CONFIG_SEQUENCE config_sequence, CONFIG_INFORMATION_CATEGORY config_information_category, CONFIG_INFORMATION1 country_code, CONFIG_INFORMATION2 number_of_employees, CONFIG_INFORMATION3 payroll_to_process_employees, CONFIG_INFORMATION4 hr_support_for_this_country from PER_RI_CONFIG_INFORMATION where CONFIG_INFORMATION_CATEGORY = 'CONFIG COUNTRY'
View Text - HTML Formatted

SELECT CONFIGURATION_CODE CONFIGURATION_CODE
, CONFIG_INFORMATION_ID CONFIG_INFORMATION_ID
, CONFIG_SEQUENCE CONFIG_SEQUENCE
, CONFIG_INFORMATION_CATEGORY CONFIG_INFORMATION_CATEGORY
, CONFIG_INFORMATION1 COUNTRY_CODE
, CONFIG_INFORMATION2 NUMBER_OF_EMPLOYEES
, CONFIG_INFORMATION3 PAYROLL_TO_PROCESS_EMPLOYEES
, CONFIG_INFORMATION4 HR_SUPPORT_FOR_THIS_COUNTRY
FROM PER_RI_CONFIG_INFORMATION
WHERE CONFIG_INFORMATION_CATEGORY = 'CONFIG COUNTRY'