DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on PER_WORKFORCE_CURRENT_X

Line 242: FROM per_workforce_current_x -- Changed the view name from per_employees_current_x to per_workforce_current_x

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

Line 439: per_workforce_current_x to enable requester from

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'

Line 445: from per_workforce_current_x

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;