View: HRI_CL_JOB_BX_V

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRI_CL_JOB_BX_V

View Text

SELECT JOB.JOB_ID ID
, JOB.NAME VALUE
, JOB.DATE_FROM DATE_FROM
, NVL(JOB.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO
, JOB.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_JOBS JOB
WHERE TRUNC(SYSDATE) BETWEEN JOB.DATE_FROM
AND NVL(JOB.DATE_TO
, HR_GENERAL.END_OF_TIME)
AND JOB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, JOB.BUSINESS_GROUP_ID) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, TO_NUMBER(NULL) BUSINESS_GROUP_ID
FROM DUAL WITH READ ONLY

Columns