Product: | PER - Human Resources |
---|---|
Description: | Join between Info type security and Position info types |
Implementation/DBA Data: | APPS.PER_INFO_TYPE_SECURITY_POT_V |
SELECT ITS.APPLICATION_ID
, ITS.RESPONSIBILITY_ID
, POT.INFORMATION_TYPE
, POT.ACTIVE_INACTIVE_FLAG
, POT.MULTIPLE_OCCURENCES_FLAG
, POT.DESCRIPTION
, POT.LEGISLATION_CODE
, POT.REQUEST_ID
, POT.PROGRAM_APPLICATION_ID
, POT.PROGRAM_ID
, POT.PROGRAM_UPDATE_DATE
, POT.OBJECT_VERSION_NUMBER
, POT.LAST_UPDATE_DATE
, POT.LAST_UPDATED_BY
, POT.LAST_UPDATE_LOGIN
, POT.CREATED_BY
, POT.CREATION_DATE
FROM PER_INFO_TYPE_SECURITY ITS
, PER_POSITION_INFO_TYPES POT
WHERE ITS.INFO_TYPE_TABLE_NAME = 'PER_POSITION_INFO_TYPES'
AND ITS.INFORMATION_TYPE = POT.INFORMATION_TYPE