Product: | PQH - Public Sector HR |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PQH_INFO_TYPE_SECURITY_RIT_V |
SELECT ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, RIT.INFORMATION_TYPE
, RIT.ACTIVE_INACTIVE_FLAG
, RIT.MULTIPLE_OCCURENCES_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
FROM PER_INFO_TYPE_SECURITY ITS
, PQH_ROLE_INFO_TYPES RIT
WHERE ITS.INFO_TYPE_TABLE_NAME = 'PQH_ROLE_INFO_TYPES'
AND ITS.INFORMATION_TYPE = RIT.INFORMATION_TYPE