Product: | PER - Human Resources |
---|---|
Description: | JP specific |
Implementation/DBA Data: | APPS.PER_JP_SPECIAL_INFORMATION |
SELECT ST.ID_FLEX_STRUCTURE_NAME
, PA.PERSON_ID
, PA.DATE_FROM
, PA.DATE_TO
, AC.ROWID ROW_ID
, AC.ANALYSIS_CRITERIA_ID
, AC.ID_FLEX_NUM
, AC.SEGMENT1
, AC.SEGMENT2
, AC.SEGMENT3
, AC.SEGMENT4
, AC.SEGMENT5
, AC.SEGMENT6
, AC.SEGMENT7
, AC.SEGMENT8
, AC.SEGMENT9
, AC.SEGMENT10
, AC.SEGMENT11
, AC.SEGMENT12
, AC.SEGMENT13
, AC.SEGMENT14
, AC.SEGMENT15
, AC.SEGMENT16
, AC.SEGMENT17
, AC.SEGMENT18
, AC.SEGMENT19
, AC.SEGMENT20
, AC.SEGMENT21
, AC.SEGMENT22
, AC.SEGMENT23
, AC.SEGMENT24
, AC.SEGMENT25
, AC.SEGMENT26
, AC.SEGMENT27
, AC.SEGMENT28
, AC.SEGMENT29
, AC.SEGMENT30
, AC.REQUEST_ID
, AC.PROGRAM_APPLICATION_ID
, AC.PROGRAM_ID
, AC.PROGRAM_UPDATE_DATE
, AC.SUMMARY_FLAG
, AC.ENABLED_FLAG
, AC.START_DATE_ACTIVE
, AC.END_DATE_ACTIVE
, AC.LAST_UPDATE_DATE
, AC.LAST_UPDATED_BY
, AC.LAST_UPDATE_LOGIN
, AC.CREATED_BY
, AC.CREATION_DATE
FROM PER_ANALYSIS_CRITERIA AC
, PER_PERSON_ANALYSES PA
, FND_ID_FLEX_STRUCTURES_VL ST
, FND_SESSIONS FND
WHERE PA.ANALYSIS_CRITERIA_ID = AC.ANALYSIS_CRITERIA_ID
AND ST.ID_FLEX_CODE = 'PEA'
AND PA.ID_FLEX_NUM = ST.ID_FLEX_NUM
AND USERENV('SESSIONID') = FND.SESSION_ID
AND FND.EFFECTIVE_DATE BETWEEN PA.DATE_FROM
AND NVL(PA.DATE_TO
, FND.EFFECTIVE_DATE)