View: GHR_INFO_TYPE_SECURITY_RIT_V

Product:	GHR - US Federal Human Resources
Description:	This view is used for validating information type eligible for a given responsibility.
Implementation/DBA Data:	APPS.GHR_INFO_TYPE_SECURITY_RIT_V

View Text

SELECT RIT.ROWID ROW_ID
, ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, RIT.INFORMATION_TYPE
, RIT.ACTIVE_INACTIVE_FLAG
, RIT.MULTIPLE_OCCURRENCES_FLAG
, RIT.DESCRIPTION
, RIT.LEGISLATION_CODE
, RIT.REQUEST_ID
, RIT.PROGRAM_APPLICATION_ID
, RIT.PROGRAM_ID
, RIT.PROGRAM_UPDATE_DATE
, RIT.OBJECT_VERSION_NUMBER
, RIT.LAST_UPDATE_DATE
, RIT.LAST_UPDATED_BY
, RIT.LAST_UPDATE_LOGIN
, RIT.CREATED_BY
, RIT.CREATION_DATE
, RIT.NOA_FAMILY_CODE
FROM PER_INFO_TYPE_SECURITY ITS
, GHR_PA_REQUEST_INFO_TYPES RIT
WHERE ITS.INFO_TYPE_TABLE_NAME = 'GHR_PA_REQUEST_INFO_TYPES'
AND ITS.INFORMATION_TYPE = RIT.INFORMATION_TYPE

Columns