APPS.BIM_EDW_LEADS_M_SIZE dependencies on EDW_LOCAL_INSTANCE

Line 17: EDW_LOCAL_INSTANCE INST

13: from (
14: select count(*) cnt
15: FROM AS_SALES_LEAD_LINES ASLL ,
16: AS_SALES_LEADS ASL ,
17: EDW_LOCAL_INSTANCE INST
18: WHERE ASLL.SALES_LEAD_ID = ASL.SALES_LEAD_ID AND
19: ( (ASL.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') )
20: OR (ASLL.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') ) )
21: AND ( ASL.DELETED_FLAG IS NULL OR ASL.DELETED_FLAG <> 'Y' )

Line 58: EDW_LOCAL_INSTANCE INST

54: avg(nvl(vsize( ASLL.SALES_LEAD_LINE_ID ), 0)),
55: avg(nvl(vsize( ASL.SALES_LEAD_ID), 0))
56: FROM AS_SALES_LEAD_LINES ASLL ,
57: AS_SALES_LEADS ASL ,
58: EDW_LOCAL_INSTANCE INST
59: WHERE ASLL.SALES_LEAD_ID = ASL.SALES_LEAD_ID AND
60: ( (ASL.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') )
61: OR (ASLL.LAST_UPDATE_DATE > TO_DATE('1000/01/01', 'YYYY/MM/DD') ) )
62: AND ( ASL.DELETED_FLAG IS NULL OR ASL.DELETED_FLAG <> 'Y' )

Line 70: from EDW_LOCAL_INSTANCE ;

66:
67: CURSOR c_2 IS
68: select
69: avg(nvl(vsize(INSTANCE_CODE), 0))
70: from EDW_LOCAL_INSTANCE ;
71:
72:
73:
74: BEGIN