APPS.BIM_EDW_INTRCTNS_F_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 20: EDW_LOCAL_INSTANCE INST

16: JTF_IH_INTERACTIONS JII,
17: HZ_PARTY_SITES HPS,
18: EDW_BIM_SOURCE_CODE_DETAILS BSCD,
19: BIM_EDW_INTRCTNS_INC INC,
20: EDW_LOCAL_INSTANCE INST
21: WHERE JIA.INTERACTION_ID = JII.INTERACTION_ID
22: AND JII.PARTY_ID = HPS.PARTY_ID (+)
23: AND HPS.IDENTIFYING_ADDRESS_FLAG(+) = 'Y'
24: AND JIA.ACTIVITY_ID = INC.PRIMARY_KEY

Line 88: from EDW_LOCAL_INSTANCE ;

84:
85: CURSOR c_3 IS
86: select
87: avg(nvl(vsize(INSTANCE_CODE), 0))
88: from EDW_LOCAL_INSTANCE ;
89:
90:
91:
92: BEGIN