APPS.BIM_EDW_TGSMT_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 17: EDW_LOCAL_INSTANCE INST

13: from (
14: select count(*) cnt
15: FROM AMS_CELLS_VL AMC ,
16: EDW_BIM_TGSMT_DENORM BTD ,
17: EDW_LOCAL_INSTANCE INST
18: WHERE AMC.CELL_ID = BTD.TARGET_SEGMENT_ID AND BTD.LEVEL_FROM_ROOT >= 8
19: AND BTD.PARENT_LEVEL_FROM_ROOT = 7
20: and amc.last_update_date between
21: p_from_date and p_to_date

Line 76: from EDW_LOCAL_INSTANCE ;

72:
73: CURSOR c_2 IS
74: select
75: avg(nvl(vsize(INSTANCE_CODE), 0))
76: from EDW_LOCAL_INSTANCE ;
77:
78:
79: BEGIN
80: