View: PER_INFO_TYPES_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_INFO_TYPES_V

View Text

SELECT 'PER_PEOPLE_INFO_TYPES' TABLE_NAME
, PIT.INFORMATION_TYPE
, PIT.LEGISLATION_CODE
FROM PER_PEOPLE_INFO_TYPES PIT
WHERE PIT.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'PER_POSITION_INFO_TYPES' TABLE_NAME
, POT.INFORMATION_TYPE
, POT.LEGISLATION_CODE
FROM PER_POSITION_INFO_TYPES POT
WHERE POT.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'PER_ASSIGNMENT_INFO_TYPES' TABLE_NAME
, AIT.INFORMATION_TYPE
, AIT.LEGISLATION_CODE
FROM PER_ASSIGNMENT_INFO_TYPES AIT
WHERE AIT.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'HR_LOCATION_INFO_TYPES' TABLE_NAME
, LIT.INFORMATION_TYPE
, LIT.LEGISLATION_CODE
FROM HR_LOCATION_INFO_TYPES LIT
WHERE LIT.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'PER_JOB_INFO_TYPES' TABLE_NAME
, JIT.INFORMATION_TYPE
, JIT.LEGISLATION_CODE
FROM PER_JOB_INFO_TYPES JIT
WHERE JIT.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'GHR_PA_REQUEST_INFO_TYPES' TABLE_NAME
, RIT.INFORMATION_TYPE
, RIT.LEGISLATION_CODE
FROM GHR_PA_REQUEST_INFO_TYPES RIT
WHERE RIT.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'PAY_ELEMENT_TYPE_INFO_TYPES' TABLE_NAME
, EIT.INFORMATION_TYPE
, EIT.LEGISLATION_CODE
FROM PAY_ELEMENT_TYPE_INFO_TYPES EIT
WHERE EIT.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'PER_PREV_JOB_INFO_TYPES' TABLE_NAME
, PJX.INFORMATION_TYPE
, PJX.LEGISLATION_CODE
FROM PER_PREV_JOB_INFO_TYPES PJX
WHERE PJX.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'PER_CONTACT_INFO_TYPES' TABLE_NAME
, CIT.INFORMATION_TYPE
, CIT.LEGISLATION_CODE
FROM PER_CONTACT_INFO_TYPES CIT
WHERE CIT.ACTIVE_INACTIVE_FLAG = 'Y' UNION SELECT 'PQH_ROLE_INFO_TYPES' TABLE_NAME
, RLS.INFORMATION_TYPE INFORMATION_TYPE
, RLS.LEGISLATION_CODE LEGISLATION_CODE
FROM PQH_ROLE_INFO_TYPES RLS
WHERE RLS.ACTIVE_INACTIVE_FLAG = 'Y'

Columns