VIEW: APPS.HRI_CL_JOB_V

Source

View Text - Preformatted

SELECT job.ID ID , job.VALUE VALUE , job.START_DATE START_DATE , job.END_DATE END_DATE , job.ORDER_BY ORDER_BY , job.business_group_id business_group_id , job.bg_security_flag_code bg_security_flag_code FROM hri_cl_job_n_v job uNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , ' ' ORDER_BY , -1 business_group_id , 'Y' bg_security_flag_code FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT JOB.ID ID
, JOB.VALUE VALUE
, JOB.START_DATE START_DATE
, JOB.END_DATE END_DATE
, JOB.ORDER_BY ORDER_BY
, JOB.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, JOB.BG_SECURITY_FLAG_CODE BG_SECURITY_FLAG_CODE
FROM HRI_CL_JOB_N_V JOB UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, ' ' ORDER_BY
, -1 BUSINESS_GROUP_ID
, 'Y' BG_SECURITY_FLAG_CODE
FROM DUAL WITH READ ONLY