APPS.BIM_EDW_OFFERS_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 17: edw_local_instance inst

13: from (
14: select count(*) cnt
15: from ams_act_offers aao ,
16: qp_list_headers_vl qlh ,
17: edw_local_instance inst
18: WHERE aao.qp_list_header_id = qlh.list_header_id and
19: ((aao.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD'))
20: or (qlh.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD')))
21: and aao.last_update_date between

Line 73: from EDW_LOCAL_INSTANCE ;

69:
70: CURSOR c_2 IS
71: select
72: avg(nvl(vsize(INSTANCE_CODE), 0))
73: from EDW_LOCAL_INSTANCE ;
74:
75: CURSOR c_3 IS
76: select
77: avg(nvl(vsize(name ), 0)),