APPS.BIM_EDW_OPP_STATUS_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 16: EDW_LOCAL_INSTANCE INST

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
20: );

Line 69: from EDW_LOCAL_INSTANCE ;

65:
66: CURSOR c_2 IS
67: select
68: avg(nvl(vsize(INSTANCE_CODE), 0))
69: from EDW_LOCAL_INSTANCE ;
70:
71:
72:
73: BEGIN