APPS.BIM_EDW_CMPSTATS_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 17: edw_local_instance inst

13: from (
14: select count(*) cnt
15: from
16: ams_user_statuses_vl aus ,
17: edw_local_instance inst
18: WHERE aus.system_status_type = 'AMS_CAMPAIGN_STATUS' and
19: aus.last_update_date between
20: p_from_date and p_to_date
21: );

Line 81: from EDW_LOCAL_INSTANCE ;

77:
78: CURSOR c_2 IS
79: select
80: avg(nvl(vsize(INSTANCE_CODE), 0))
81: from EDW_LOCAL_INSTANCE ;
82:
83:
84:
85: BEGIN