DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_SV dependencies on PER_WORKFORCE_CURRENT_X

Line 699: per_workforce_current_x to enable requester from

695: /* Added the validation on deliver to person
696: for Bug 2392074.
697: */
698: /* Replace view hr_employees_current_v with view
699: per_workforce_current_x to enable requester from
700: another BG for bug 9157396
701: */
702: SELECT nvl(max(hre.full_name),'notfound')
703: INTO x_del_per_val

Line 704: FROM per_workforce_current_x hre

700: another BG for bug 9157396
701: */
702: SELECT nvl(max(hre.full_name),'notfound')
703: INTO x_del_per_val
704: FROM per_workforce_current_x hre
705: WHERE (hre.termination_date IS NULL
706: OR hre.termination_date > sysdate)
707: AND hre.person_id = x_deliver_to_person_id;
708: