DBA Data[Home] [Help]

APPS.RCV_INT_ORG_TRANSFER dependencies on HR_EMPLOYEES_CURRENT_V

Line 793: FROM hr_employees_current_v hre

789: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
790: BEGIN
791: SELECT NVL(MAX(hre.full_name), 'notfound')
792: INTO x_full_name
793: FROM hr_employees_current_v hre
794: WHERE ( hre.inactive_date IS NULL
795: OR hre.inactive_date > SYSDATE)
796: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
797:

Line 2114: FROM hr_employees_current_v hre

2110: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
2111: BEGIN
2112: SELECT NVL(MAX(hre.full_name), 'notfound')
2113: INTO x_full_name
2114: FROM hr_employees_current_v hre
2115: WHERE ( hre.inactive_date IS NULL
2116: OR hre.inactive_date > SYSDATE)
2117: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
2118: