43: WHERE lookup_type = 'IT_EMP_CAT'
44: AND lookup_code = p_employment_category;
45: EXCEPTION
46: WHEN no_data_found THEN
47: hr_utility.set_message(800, 'HR_IT_INVALID_EMP_CAT');
48: hr_utility.raise_error;
49: END;
50: END IF;
51: END extra_assignment_checks;
44: AND lookup_code = p_employment_category;
45: EXCEPTION
46: WHEN no_data_found THEN
47: hr_utility.set_message(800, 'HR_IT_INVALID_EMP_CAT');
48: hr_utility.raise_error;
49: END;
50: END IF;
51: END extra_assignment_checks;
52: END hr_it_extra_assgt_rules;