View: HRI_CL_RQNVAC_VACNCY_H_V

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

View Text

SELECT VAC.VACANCY_ID ID
, VAC.NAME VALUE
, VAC.DATE_FROM START_DATE
, NVL(VAC.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, VAC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_VACANCIES VAC UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -1 BUSINESS_GROUP_ID
FROM DUAL WITH READ ONLY

Columns