APPS.BIM_EDW_OPRNTIES_F_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 19: EDW_LOCAL_INSTANCE INST

15: FROM AS_LEAD_LINES_ALL ASLL,
16: AS_LEADS_ALL ASL,
17: EDW_BIM_SOURCE_CODE_DETAILS BSCD,
18: BIM_EDW_OPRNTIES_INC INC,
19: EDW_LOCAL_INSTANCE INST
20: WHERE ASL.LEAD_ID = ASLL.LEAD_ID
21: AND ASLL.LEAD_LINE_ID = INC.PRIMARY_KEY
22: AND NVL(ASLL.SOURCE_PROMOTION_ID,
23: -999) = BSCD.SOURCE_CODE_ID

Line 105: from EDW_LOCAL_INSTANCE ;

101:
102: CURSOR c_4 IS
103: select
104: avg(nvl(vsize(INSTANCE_CODE), 0))
105: from EDW_LOCAL_INSTANCE ;
106:
107:
108:
109: BEGIN