VIEW: APPS.HRI_CL_JOB_BX_V

Source

View Text - Preformatted

SELECT job.job_id ID , job.name VALUE , job.date_from start_date , nvl(job.date_to,hr_general.end_of_time) end_date , 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 start_date , hr_general.end_of_time end_date , to_number(NULL) business_group_id FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT JOB.JOB_ID ID
, JOB.NAME VALUE
, JOB.DATE_FROM START_DATE
, NVL(JOB.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, 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 START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, TO_NUMBER(NULL) BUSINESS_GROUP_ID
FROM DUAL WITH READ ONLY