11: CURSOR c_cnt_rows IS
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM JTF_IH_REASONS_VL RSN ,
16: EDW_LOCAL_INSTANCE INST
17: where RSN.last_update_date between
18: p_from_date and p_to_date
19: );
51: avg(nvl(vsize(REASON_ID ), 0)),
52: avg(nvl(vsize(SHORT_DESCRIPTION ), 0)),
53: avg(nvl(vsize(REASON_CODE ), 0)),
54: avg(nvl(vsize(LONG_DESCRIPTION ), 0))
55: FROM JTF_IH_REASONS_VL
56: WHERE
57: last_update_date between
58: p_from_date and p_to_date;
59: