APPS.EDW_OPI_ACTV_MOPM_SZ dependencies on EDW_LOCAL_INSTANCE

Line 37: from edw_local_instance;

33: x_last_update_date NUMBER := x_date;
34: x_creation_date NUMBER := x_date;
35: cursor CUR_INSTANCE_SIZE is
36: select avg(nvl(vsize(instance_code),0))
37: from edw_local_instance;
38:
39: CURSOR CUR_OPM_ACTIVITY_SIZES IS
40: SELECT avg(nvl(vsize(ACTIVITY),0)),
41: avg(nvl(vsize(ACTIVITY_DESC),0)),