DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV dependencies on HR_EMPLOYEES_CURRENT_V

Line 2395: FROM hr_employees_current_v hre

2391: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN
2392: BEGIN
2393: SELECT NVL(MAX(hre.full_name), 'notfound')
2394: INTO x_full_name
2395: FROM hr_employees_current_v hre
2396: WHERE ( hre.inactive_date IS NULL
2397: OR hre.inactive_date > SYSDATE)
2398: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
2399: