DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on HR_EMPLOYEES_CURRENT_V

Line 1327: FROM hr_employees_current_v hre

1323: x_progress := '010';
1324:
1325: SELECT NVL(MAX(hre.full_name), 'notfound')
1326: INTO x_full_name
1327: FROM hr_employees_current_v hre
1328: WHERE ( hre.inactive_date IS NULL
1329: OR hre.inactive_date > SYSDATE)
1330: AND hre.employee_id = x_employee_record.employee_id;
1331: