APPS.HRI_EDW_DIM_JOB dependencies on PER_JOB_EXTRA_INFO

Line 21: FROM per_job_extra_info jei,

17: /* Cursor holding all job categories (codes and lookups) */
18: /* associated with the given job */
19: CURSOR job_cat_cur IS
20: SELECT jei.jei_information1, hrl.meaning
21: FROM per_job_extra_info jei,
22: hr_lookups hrl
23: WHERE jei.job_id = p_job_id
24: AND hrl.lookup_type = 'JOB_CATEGORIES'
25: AND hrl.lookup_code = jei.jei_information1