APPS.HR_IT_EXTRA_ASSGT_RULES dependencies on HR_LOOKUPS

Line 42: FROM hr_lookups

38: IF val_changed(p_employment_category) AND p_employment_category IS NOT NULL THEN
39: BEGIN
40: SELECT lookup_code
41: INTO l_emp_cat
42: FROM hr_lookups
43: WHERE lookup_type = 'IT_EMP_CAT'
44: AND lookup_code = p_employment_category;
45: EXCEPTION
46: WHEN no_data_found THEN