APPS.BIM_EDW_LEAD_STATUS_M_SIZE dependencies on AS_STATUSES_VL

Line 15: FROM AS_STATUSES_VL AST ,

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.LEAD_FLAG = 'Y' AND AST.ENABLED_FLAG = 'Y'
18: and ast.last_update_date between
19: p_from_date and p_to_date

Line 55: FROM AS_STATUSES_VL

51: SELECT
52: avg(nvl(vsize(MEANING ), 0)),
53: avg(nvl(vsize(STATUS_CODE ), 0)),
54: avg(nvl(vsize(DESCRIPTION ), 0))
55: FROM AS_STATUSES_VL
56: where last_update_date between
57: p_from_date and p_to_date ;
58:
59: