15: FROM AS_SALES_LEAD_LINES ASLL,
16: AS_SALES_LEADS ASL,
17: EDW_BIM_SOURCE_CODE_DETAILS BSCD,
18: BIM_EDW_LEADS_INC INC,
19: EDW_LOCAL_INSTANCE INST
20: WHERE ASL.SALES_LEAD_ID = ASLL.SALES_LEAD_ID
21: AND ASLL.SALES_LEAD_LINE_ID = INC.PRIMARY_KEY
22: AND NVL(ASLL.SOURCE_PROMOTION_ID,
23: -999) = BSCD.SOURCE_CODE_ID AND ( ( ASL.LAST_UPDATE_DATE
93:
94: CURSOR c_4 IS
95: select
96: avg(nvl(vsize(INSTANCE_CODE), 0))
97: from EDW_LOCAL_INSTANCE ;
98:
99:
100:
101: BEGIN