FND Design Data [Home] [Help]

View: PER_SUCCESSION_PLANNING_LOV

Product: PER - Human Resources
Description: Used to support user interface
Implementation/DBA Data: ViewAPPS.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