APPS.HRI_EDW_DIM_JOB dependencies on HR_LOOKUPS

Line 22: hr_lookups hrl

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
26: AND information_type = 'Job Category';

Line 39: hr_lookups hrl

35: /* Cursor to get other lookup code */
36: CURSOR other_cur IS
37: SELECT hrl.meaning
38: FROM hri_job_category_sets jsc,
39: hr_lookups hrl
40: WHERE jsc.job_category_set = p_sequence
41: AND jsc.member_lookup_code IS NULL
42: AND hrl.lookup_type = 'HRI_JOB_CATEGORY_SETS'
43: AND hrl.lookup_code = jsc.other_lookup_code;