Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_SPECIAL_INFO_TYPES_V |
SELECT X.ROWID
, X.SPECIAL_INFORMATION_TYPE_ID
, X.BUSINESS_GROUP_ID
, X.ID_FLEX_NUM
, F.ID_FLEX_STRUCTURE_NAME
, NULL
, X.COMMENTS
, X.ENABLED_FLAG
, X.REQUEST_ID
, X.PROGRAM_APPLICATION_ID
, X.PROGRAM_ID
, X.PROGRAM_UPDATE_DATE
, X.ATTRIBUTE_CATEGORY
, X.ATTRIBUTE1
, X.ATTRIBUTE2
, X.ATTRIBUTE3
, X.ATTRIBUTE4
, X.ATTRIBUTE5
, X.ATTRIBUTE6
, X.ATTRIBUTE7
, X.ATTRIBUTE8
, X.ATTRIBUTE9
, X.ATTRIBUTE10
, X.ATTRIBUTE11
, X.ATTRIBUTE12
, X.ATTRIBUTE13
, X.ATTRIBUTE14
, X.ATTRIBUTE15
, X.ATTRIBUTE16
, X.ATTRIBUTE17
, X.ATTRIBUTE18
, X.ATTRIBUTE19
, X.ATTRIBUTE20
, X.LAST_UPDATE_DATE
, X.LAST_UPDATED_BY
, X.LAST_UPDATE_LOGIN
, X.CREATED_BY
, X.CREATION_DATE
FROM PER_SPECIAL_INFO_TYPES X
, FND_ID_FLEX_STRUCTURES_VL F
WHERE X.ID_FLEX_NUM = F.ID_FLEX_NUM
AND F.ID_FLEX_CODE = 'PEA'