APPS.BIM_EDW_CMPGNS_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 17: EDW_LOCAL_INSTANCE INST

13: from (
14: select count(*) cnt
15: FROM AMS_CAMPAIGN_SCHEDULES AMS ,
16: AMS_CAMPAIGNS_VL AMC ,
17: EDW_LOCAL_INSTANCE INST
18: WHERE AMS.CAMPAIGN_ID = AMC.CAMPAIGN_ID
19: and
20: AMS.last_update_date between
21: p_from_date and p_to_date

Line 92: from EDW_LOCAL_INSTANCE ;

88:
89: CURSOR c_3 IS
90: select
91: avg(nvl(vsize(INSTANCE_CODE), 0))
92: from EDW_LOCAL_INSTANCE ;
93:
94:
95:
96: BEGIN