11: CURSOR c_cnt_rows IS
12: select sum(cnt)
13: from (
14: select count(*) cnt
15: FROM AS_STATUSES_VL AST ,
16: EDW_LOCAL_INSTANCE INST
17: WHERE AST.OPP_FLAG = 'Y' AND AST.ENABLED_FLAG = 'Y'
18: and ast.last_update_date between
19: p_from_date and p_to_date
55: avg(nvl(vsize(STATUS_CODE ), 0)),
56: avg(nvl(vsize(DESCRIPTION ), 0)),
57: avg(nvl(vsize(OPP_OPEN_STATUS_FLAG ), 0)),
58: avg(nvl(vsize(FORECAST_ROLLUP_FLAG ), 0))
59: FROM AS_STATUSES_VL AST
60: WHERE AST.OPP_FLAG = 'Y' AND AST.ENABLED_FLAG = 'Y'
61: and AST.last_update_date between
62: p_from_date and p_to_date;
63: