VIEW: APPS.PER_SUCCESSION_PLANNING_LOV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')