DBA Data[Home] [Help]

APPS.RCV_INT_ORDER_PP_PVT dependencies on HR_EMPLOYEES_CURRENT_V

Line 1454: FROM hr_employees_current_v hre

1450: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
1451: BEGIN
1452: SELECT NVL(MAX(hre.full_name), 'notfound')
1453: INTO x_full_name
1454: FROM hr_employees_current_v hre
1455: WHERE ( hre.inactive_date IS NULL
1456: OR hre.inactive_date > SYSDATE)
1457: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
1458: