11:
12: /* Cursor description */
13: CURSOR row_count_cur IS
14: SELECT count(vacancy_id) total
15: FROM per_all_vacancies
16: WHERE NVL(last_update_date, to_date('01-01-2000','DD-MM-YYYY'))
17: BETWEEN p_from_date AND p_to_date;
18:
19:
99: ,avg(nvl(vsize(requisition_id),0))
100: ,avg(nvl(vsize(vacancy_id),0))
101: ,avg(nvl(vsize(hr_general.decode_lookup('BUDGET_MEASUREMENT_TYPE',budget_measurement_type)),0))
102: ,avg(nvl(vsize(hr_general.decode_lookup('VACANCY_STATUS',status)),0))
103: FROM per_all_vacancies
104: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
105:
106: BEGIN
107: /* Selects the length of the instance code */