View: PER_POS_STRUCTURE_ELEMENTS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_POS_STRUCTURE_ELEMENTS_V

View Text

SELECT NVL (PSE.ROWID
, POS.ROWID)
, NVL (PSE.POS_STRUCTURE_ELEMENT_ID
, 0)
, NVL (PSE.BUSINESS_GROUP_ID
, POS.BUSINESS_GROUP_ID)
, NVL (PSE.POS_STRUCTURE_VERSION_ID
, 0)
, NVL (PSE.SUBORDINATE_POSITION_ID
, POS.POSITION_ID)
, POS.ORGANIZATION_ID
, NVL (PSE.PARENT_POSITION_ID
, 0)
, NVL (PSE.REQUEST_ID
, POS.REQUEST_ID)
, NVL (PSE.PROGRAM_APPLICATION_ID
, POS.PROGRAM_APPLICATION_ID)
, NVL (PSE.PROGRAM_ID
, POS.PROGRAM_ID)
, NVL (PSE.PROGRAM_UPDATE_DATE
, POS.PROGRAM_UPDATE_DATE)
, NVL (PSE.LAST_UPDATE_DATE
, POS.LAST_UPDATE_DATE)
, NVL (PSE.LAST_UPDATED_BY
, POS.LAST_UPDATED_BY)
, NVL (PSE.LAST_UPDATE_LOGIN
, POS.LAST_UPDATE_LOGIN)
, NVL (PSE.CREATED_BY
, POS.CREATED_BY)
, NVL (PSE.CREATION_DATE
, POS.CREATION_DATE)
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(POS.POSITION_ID)
FROM PER_POS_STRUCTURE_ELEMENTS PSE
, HR_ALL_POSITIONS_F POS
, HR_ALL_POSITIONS_F_TL PFT
WHERE PSE.SUBORDINATE_POSITION_ID (+) = POS.POSITION_ID
AND POS.EFFECTIVE_END_DATE = TO_DATE('31124712'
, 'DDMMYYYY')
AND POS.POSITION_ID = PFT.POSITION_ID
AND PFT.LANGUAGE = USERENV('LANG')

Columns