DBA Data[Home] [Help]

APPS.RCV_INT_ORDER_PP_PVT dependencies on HR_EMPLOYEES_CURRENT_V

Line 1513: FROM hr_employees_current_v hre

1509: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
1510: BEGIN
1511: SELECT NVL(MAX(hre.full_name), 'notfound')
1512: INTO x_full_name
1513: FROM hr_employees_current_v hre
1514: WHERE ( hre.inactive_date IS NULL
1515: OR hre.inactive_date > SYSDATE)
1516: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
1517: