VIEW: APPS.HRI_JOB_LOV_V

Source

View Text - Preformatted

SELECT -1, ' ' from sys.dual UNION select job_id, name from per_jobs where business_group_id = hr_bis.get_sec_profile_bg_id WITH READ ONLY

View Text - HTML Formatted

SELECT -1
, ' '
FROM SYS.DUAL UNION SELECT JOB_ID
, NAME
FROM PER_JOBS
WHERE BUSINESS_GROUP_ID = HR_BIS.GET_SEC_PROFILE_BG_ID WITH READ ONLY