APPS.RCV_ROI_TRANSACTION dependencies on HR_EMPLOYEES_CURRENT_V

Line 5038: FROM hr_employees_current_v hre

5034: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
5035: BEGIN
5036: SELECT NVL(MAX(hre.full_name), 'notfound')
5037: INTO x_full_name
5038: FROM hr_employees_current_v hre
5039: WHERE ( hre.inactive_date IS NULL
5040: OR hre.inactive_date > SYSDATE)
5041: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
5042:

Line 6555: FROM hr_employees_current_v hre

6551: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
6552: BEGIN
6553: SELECT NVL(MAX(hre.full_name), 'notfound')
6554: INTO x_full_name
6555: FROM hr_employees_current_v hre
6556: WHERE ( hre.inactive_date IS NULL
6557: OR hre.inactive_date > SYSDATE)
6558: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
6559:

Line 11287: FROM hr_employees_current_v hre

11283: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
11284: BEGIN
11285: SELECT NVL(MAX(hre.full_name), 'notfound')
11286: INTO x_full_name
11287: FROM hr_employees_current_v hre
11288: WHERE ( hre.inactive_date IS NULL
11289: OR hre.inactive_date > SYSDATE)
11290: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
11291: