Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_EXPANDED_POSITIONS |
SELECT PP.POSITION_ID
, PP.BUSINESS_GROUP_ID
, PP.JOB_ID
, PP.ORGANIZATION_ID
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
, PP.DATE_EFFECTIVE
, PP.LAST_UPDATE_LOGIN
, PP.CREATED_BY
, PP.CREATION_DATE
, PP.REQUEST_ID
, PP.PROGRAM_APPLICATION_ID
, PP.PROGRAM_ID
, PP.PROGRAM_UPDATE_DATE
, PPD.POSITION_DEFINITION_ID
, PP.COMMENTS
, HR_GENERAL.GET_POSITION_DATE_END (PP.POSITION_ID)
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PP.POSITION_ID)
, PP.LOCATION_ID
, ID_FLEX_NUM
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
FROM HR_POSITIONS_F PP
, PER_POSITION_DEFINITIONS PPD
WHERE PPD.POSITION_DEFINITION_ID = HR_GENERAL.DECODE_LATEST_POSITION_DEF_ID(PP.POSITION_ID)
AND PP.EFFECTIVE_END_DATE = TO_DATE('31124712'
, 'DDMMYYYY')