Product: | PER - Human Resources |
---|---|
Description: | View of special information types for a person, used by People Management form |
Implementation/DBA Data: | APPS.PER_QH_SIT_V |
SELECT PPA.PERSON_ANALYSIS_ID
, PPA.BUSINESS_GROUP_ID
, PPA.ANALYSIS_CRITERIA_ID
, PPA.PERSON_ID
, PPA.DATE_FROM
, PPA.DATE_TO
, PAC.ID_FLEX_NUM
, PAC.SUMMARY_FLAG
, PAC.ENABLED_FLAG
, PAC.SEGMENT1
, PAC.SEGMENT2
, PAC.SEGMENT3
, PAC.SEGMENT4
, PAC.SEGMENT5
, PAC.SEGMENT6
, PAC.SEGMENT7
, PAC.SEGMENT8
, PAC.SEGMENT9
, PAC.SEGMENT10
, PAC.SEGMENT11
, PAC.SEGMENT12
, PAC.SEGMENT13
, PAC.SEGMENT14
, PAC.SEGMENT15
, PAC.SEGMENT16
, PAC.SEGMENT17
, PAC.SEGMENT18
, PAC.SEGMENT19
, PAC.SEGMENT20
, PAC.SEGMENT21
, PAC.SEGMENT22
, PAC.SEGMENT23
, PAC.SEGMENT24
, PAC.SEGMENT25
, PAC.SEGMENT26
, PAC.SEGMENT27
, PAC.SEGMENT28
, PAC.SEGMENT29
, PAC.SEGMENT30
, PPA.ATTRIBUTE_CATEGORY
, PPA.ATTRIBUTE1
, PPA.ATTRIBUTE2
, PPA.ATTRIBUTE3
, PPA.ATTRIBUTE4
, PPA.ATTRIBUTE5
, PPA.ATTRIBUTE6
, PPA.ATTRIBUTE7
, PPA.ATTRIBUTE8
, PPA.ATTRIBUTE9
, PPA.ATTRIBUTE10
, PPA.ATTRIBUTE11
, PPA.ATTRIBUTE12
, PPA.ATTRIBUTE13
, PPA.ATTRIBUTE14
, PPA.ATTRIBUTE15
, PPA.ATTRIBUTE16
, PPA.ATTRIBUTE17
, PPA.ATTRIBUTE18
, PPA.ATTRIBUTE19
, PPA.ATTRIBUTE20
, PPA.OBJECT_VERSION_NUMBER
FROM PER_ANALYSIS_CRITERIA PAC
, PER_PERSON_ANALYSES PPA
WHERE PPA.ANALYSIS_CRITERIA_ID=PAC.ANALYSIS_CRITERIA_ID