238: where employee_id = x_employee_id; */
239:
240: SELECT full_name
241: INTO x_name
242: FROM per_workforce_current_x -- Changed the view name from per_employees_current_x to per_workforce_current_x
243: WHERE person_id = x_employee_id
244: AND ROWNUM = 1;
245:
246: -- End of Bug 8270296
435: x_progress := 30;
436: BEGIN
437:
438: /* Replace view hr_employees_current_v with view
439: per_workforce_current_x to enable requester from
440: another BG for bug 9157396
441: */
442: if x_deliver_to_person_id is not null then--Bug#6497729
443: select 'Check to see if deliver_to_person_id is valid'
441: */
442: if x_deliver_to_person_id is not null then--Bug#6497729
443: select 'Check to see if deliver_to_person_id is valid'
444: into x_del_per_val
445: from per_workforce_current_x
446: WHERE (termination_date IS NULL
447: OR
448: termination_date > x_date)
449: AND person_id = x_deliver_to_person_id;