APPS.EDW_HR_SERVICE_M_SIZING dependencies on HRI_SERVICE_BANDS

Line 15: FROM hri_service_bands bnds

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

Line 73: hri_service_bands bnds

69: ,avg(nvl(vsize(bnds.band_min_total_months),0))
70: ,avg(nvl(vsize(bnds.band_min_total_weeks),0))
71: ,avg(nvl(vsize(bnds.band_min_total_days),0))
72: FROM
73: hri_service_bands bnds
74: WHERE bnds.last_update_date BETWEEN p_from_date AND p_to_date;
75:
76: BEGIN
77: