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