APPS.EDW_HR_REC_ACT_M_SIZING dependencies on HR_ALL_ORGANIZATION_UNITS
Line 89: FROM hr_all_organization_units
85: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
86:
87: CURSOR bus_cur IS
88: SELECT avg(nvl(vsize(name),0)) 89: FROM hr_all_organization_units 90: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
91:
92: CURSOR hrl_cur IS
93: SELECT avg(nvl(vsize(lookup_code),0))