12:
13: /* Cursor description */
14: CURSOR row_count_cur IS
15: SELECT count(position_id) total
16: FROM per_all_positions
17: WHERE NVL(last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
18: BETWEEN p_from_date AND p_to_date;
19:
20: BEGIN
80: ,avg(nvl(vsize(time_normal_start),0))
81: ,avg(nvl(vsize(time_normal_finish),0))
82: ,avg(nvl(vsize(working_hours),0))
83: ,avg(nvl(vsize(hr_general.decode_lookup('FREQUENCY',frequency)),0))
84: FROM per_all_positions
85: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
86:
87: CURSOR bgr_cur IS
88: SELECT