172:
173: begin
174: select 'Y'
175: into l_employee_is_active
176: from per_workforce_current_x -- Bug 3176205: view name changed from hr_employees_current_v to
177: where person_id = p_employee_id; -- per_workforce_current_x to consider Contingent workers as well.
178:
179: exception
180: when no_data_found then
173: begin
174: select 'Y'
175: into l_employee_is_active
176: from per_workforce_current_x -- Bug 3176205: view name changed from hr_employees_current_v to
177: where person_id = p_employee_id; -- per_workforce_current_x to consider Contingent workers as well.
178:
179: exception
180: when no_data_found then
181: l_employee_is_active := 'N';