Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_CONTACT_INFO_TYPES_VL |
SELECT CIT.ROWID
, CIT.INFORMATION_TYPE
, CIT.ACTIVE_INACTIVE_FLAG
, CITTL.DESCRIPTION
, CIT.LEGISLATION_CODE
, CIT.MULTIPLE_OCCURENCES_FLAG
, CIT.REQUEST_ID
, CIT.PROGRAM_APPLICATION_ID
, CIT.PROGRAM_ID
, CIT.PROGRAM_UPDATE_DATE
, CIT.LAST_UPDATE_DATE
, CIT.LAST_UPDATED_BY
, CIT.LAST_UPDATE_LOGIN
, CIT.CREATED_BY
, CIT.CREATION_DATE
, CIT.OBJECT_VERSION_NUMBER
FROM PER_CONTACT_INFO_TYPES CIT
, PER_CONTACT_INFO_TYPES_TL CITTL
WHERE CIT.INFORMATION_TYPE = CITTL.INFORMATION_TYPE
AND CITTL.LANGUAGE = USERENV('LANG')