VIEW: APPS.PER_INFO_TYPE_SECURITY_LIT_V

Source

View Text - Preformatted

SELECT ITS.APPLICATION_ID , ITS.RESPONSIBILITY_ID , LIT.INFORMATION_TYPE , LIT.ACTIVE_INACTIVE_FLAG , LIT.MULTIPLE_OCCURENCES_FLAG , LIT.DESCRIPTION , LIT.LEGISLATION_CODE , LIT.REQUEST_ID , LIT.PROGRAM_APPLICATION_ID , LIT.PROGRAM_ID , LIT.PROGRAM_UPDATE_DATE , LIT.OBJECT_VERSION_NUMBER , LIT.LAST_UPDATE_DATE , LIT.LAST_UPDATED_BY , LIT.LAST_UPDATE_LOGIN , LIT.CREATED_BY , LIT.CREATION_DATE FROM PER_INFO_TYPE_SECURITY ITS, HR_LOCATION_INFO_TYPES LIT WHERE ITS.INFO_TYPE_TABLE_NAME = 'HR_LOCATION_INFO_TYPES' AND ITS.INFORMATION_TYPE = LIT.INFORMATION_TYPE

View Text - HTML Formatted

SELECT ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, LIT.INFORMATION_TYPE
, LIT.ACTIVE_INACTIVE_FLAG
, LIT.MULTIPLE_OCCURENCES_FLAG
, LIT.DESCRIPTION
, LIT.LEGISLATION_CODE
, LIT.REQUEST_ID
, LIT.PROGRAM_APPLICATION_ID
, LIT.PROGRAM_ID
, LIT.PROGRAM_UPDATE_DATE
, LIT.OBJECT_VERSION_NUMBER
, LIT.LAST_UPDATE_DATE
, LIT.LAST_UPDATED_BY
, LIT.LAST_UPDATE_LOGIN
, LIT.CREATED_BY
, LIT.CREATION_DATE
FROM PER_INFO_TYPE_SECURITY ITS
, HR_LOCATION_INFO_TYPES LIT
WHERE ITS.INFO_TYPE_TABLE_NAME = 'HR_LOCATION_INFO_TYPES'
AND ITS.INFORMATION_TYPE = LIT.INFORMATION_TYPE