APPS.EDW_HR_AGE_BAND_M_SIZING dependencies on HRI_AGE_BANDS

Line 15: FROM hri_age_bands bnds

11:
12: /* Cursor description */
13: CURSOR row_count_cur IS
14: SELECT count(bnds.band_min_total_months) total
15: FROM hri_age_bands bnds
16: WHERE NVL(bnds.last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
17: BETWEEN p_from_date AND p_to_date;
18:
19: BEGIN

Line 61: FROM hri_age_bands

57: CURSOR age_cur IS
58: SELECT
59: avg(nvl(vsize(band_min_total_months),0))
60: ,avg(nvl(vsize(band_max_total_months),0))
61: FROM hri_age_bands
62: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
63:
64: BEGIN
65: