APPS.EDW_HR_JOBS_M_SIZING dependencies on HR_ALL_ORGANIZATION_UNITS

Line 113: FROM hr_all_organization_units bgr, per_jobs job

109: CURSOR bgr_cur IS
110: SELECT
111: avg(nvl(vsize(organization_id),0))
112: ,avg(nvl(vsize(bgr.name),0))
113: FROM hr_all_organization_units bgr, per_jobs job
114: WHERE job.last_update_date BETWEEN p_from_date AND p_to_date;
115:
116:
117: BEGIN