Product: | PER - Human Resources |
---|---|
Description: | Join between Info type security and People info types |
Implementation/DBA Data: |
![]() |
SELECT ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, PIT.INFORMATION_TYPE
, PIT.ACTIVE_INACTIVE_FLAG
, PIT.MULTIPLE_OCCURENCES_FLAG
, PIT.DESCRIPTION
, PIT.LEGISLATION_CODE
, PIT.REQUEST_ID
, PIT.PROGRAM_APPLICATION_ID
, PIT.PROGRAM_ID
, PIT.PROGRAM_UPDATE_DATE
, PIT.OBJECT_VERSION_NUMBER
, PIT.LAST_UPDATE_DATE
, PIT.LAST_UPDATED_BY
, PIT.LAST_UPDATE_LOGIN
, PIT.CREATED_BY
, PIT.CREATION_DATE
FROM PER_INFO_TYPE_SECURITY ITS
, PER_PEOPLE_INFO_TYPES PIT
WHERE ITS.INFO_TYPE_TABLE_NAME = 'PER_PEOPLE_INFO_TYPES'
AND ITS.INFORMATION_TYPE = PIT.INFORMATION_TYPE