38: FETCH cur_check_ppsn INTO l_check_ppsn;
39: CLOSE cur_check_ppsn;
40:
41: IF l_check_ppsn = 0 THEN
42: hr_utility.set_message(800,'HR_IE_PPSN_OVERRIDE');
43: hr_utility.raise_error;
44: END IF;
45: END IF;
46: END;
39: CLOSE cur_check_ppsn;
40:
41: IF l_check_ppsn = 0 THEN
42: hr_utility.set_message(800,'HR_IE_PPSN_OVERRIDE');
43: hr_utility.raise_error;
44: END IF;
45: END IF;
46: END;
47:
82: FETCH cur_check_ppsn INTO l_check_ppsn;
83: CLOSE cur_check_ppsn;
84:
85: IF l_check_ppsn = 0 THEN
86: hr_utility.set_message(800,'HR_IE_PPSN_OVERRIDE');
87: hr_utility.raise_error;
88: END IF;
89: END IF;
90: END;
83: CLOSE cur_check_ppsn;
84:
85: IF l_check_ppsn = 0 THEN
86: hr_utility.set_message(800,'HR_IE_PPSN_OVERRIDE');
87: hr_utility.raise_error;
88: END IF;
89: END IF;
90: END;
91: