DBA Data[Home] [Help]

APPS.RCV_INT_ORG_TRANSFER dependencies on HR_EMPLOYEES_CURRENT_V

Line 826: FROM hr_employees_current_v hre

822: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
823: BEGIN
824: SELECT NVL(MAX(hre.full_name), 'notfound')
825: INTO x_full_name
826: FROM hr_employees_current_v hre
827: WHERE ( hre.inactive_date IS NULL
828: OR hre.inactive_date > SYSDATE)
829: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
830:

Line 2189: FROM hr_employees_current_v hre

2185: IF (temp_cascaded_table(current_n).deliver_to_person_id IS NOT NULL) THEN --{
2186: BEGIN
2187: SELECT NVL(MAX(hre.full_name), 'notfound')
2188: INTO x_full_name
2189: FROM hr_employees_current_v hre
2190: WHERE ( hre.inactive_date IS NULL
2191: OR hre.inactive_date > SYSDATE)
2192: AND hre.employee_id = temp_cascaded_table(current_n).deliver_to_person_id;
2193: