View: HRI_CL_POSITION_INHV_H_V

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.HRI_CL_POSITION_INHV_H_V

View Text

SELECT POS.POSITION_ID ID
, POS.NAME VALUE
, POS.DATE_EFFECTIVE START_DATE
, NVL(POS.DATE_END
, HR_GENERAL.END_OF_TIME) END_DATE
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, PHS.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PHS.POS_STRUCTURE_VERSION_ID POS_STRUCTURE_VERSION_ID
FROM PER_POSITIONS POS
, HRI_CS_POSH_V PHS
WHERE PHS.SUB_RELATIVE_LEVEL = 0
AND POS.POSITION_ID = PHS.SUP_POSITION_ID WITH READ ONLY

Columns