156:
157: CURSOR org_cur IS
158: SELECT
159: avg(nvl(vsize(name),0))
160: ,avg(nvl(vsize(hr_general.decode_lookup('INTL_EXTL',internal_external_flag)),0))
161: ,avg(nvl(vsize(type),0))
162: ,avg(nvl(vsize(hr_general.decode_lookup('ORG_TYPE',type)),0))
163: ,avg(nvl(vsize(organization_id),0))
164: FROM hr_all_organization_units
158: SELECT
159: avg(nvl(vsize(name),0))
160: ,avg(nvl(vsize(hr_general.decode_lookup('INTL_EXTL',internal_external_flag)),0))
161: ,avg(nvl(vsize(type),0))
162: ,avg(nvl(vsize(hr_general.decode_lookup('ORG_TYPE',type)),0))
163: ,avg(nvl(vsize(organization_id),0))
164: FROM hr_all_organization_units
165: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
166: