APPS.RCV_ROI_TRANSACTION dependencies on HR_EMPLOYEES_CURRENT_V

Line 5680: FROM hr_employees_current_v hre

5676: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
5677: BEGIN
5678: SELECT NVL(MAX(hre.full_name), 'notfound')
5679: INTO x_full_name
5680: FROM hr_employees_current_v hre
5681: WHERE ( hre.inactive_date IS NULL
5682: OR hre.inactive_date > SYSDATE)
5683: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
5684:

Line 7263: FROM hr_employees_current_v hre

7259: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
7260: BEGIN
7261: SELECT NVL(MAX(hre.full_name), 'notfound')
7262: INTO x_full_name
7263: FROM hr_employees_current_v hre
7264: WHERE ( hre.inactive_date IS NULL
7265: OR hre.inactive_date > SYSDATE)
7266: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
7267:

Line 12583: FROM hr_employees_current_v hre

12579: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
12580: BEGIN
12581: SELECT NVL(MAX(hre.full_name), 'notfound')
12582: INTO x_full_name
12583: FROM hr_employees_current_v hre
12584: WHERE ( hre.inactive_date IS NULL
12585: OR hre.inactive_date > SYSDATE)
12586: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
12587: