[Home] [Help]
View: PER_SUCCESSION_PLANNING_LOV
View Text
SELECT POSITION_ID
, BUSINESS_GROUP_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(POSITION_ID)
FROM HR_POSITIONS_F
WHERE EFFECTIVE_END_DATE = TO_DATE('31124712'
, 'DDMMYYYY')
Columns
Name |
POSITION_ID |
BUSINESS_GROUP_ID |
NAME |