DBA Data[Home] [Help]

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))