APPS.IEO_SUM_AVB_RECORD dependencies on IEO_CP_LIST_STATS_ALL

Line 13: from IEO_CP_LIST_STATS_ALL A, IEO_CP_SVC_LISTS_ALL B

9: IS
10: ieototal NUMBER(15) := 0;
11: BEGIN
12: select sum(A.REC_AVAILABLE) into ieototal
13: from IEO_CP_LIST_STATS_ALL A, IEO_CP_SVC_LISTS_ALL B
14: where A.LIST_SRV_NAME = LIST_SRV_NAME_Value
15: and A.LIST_SRV_NAME = B.LIST_SRV_NAME
16: and A.LIST_NAME = B.LIST_NAME
17: and B.LIST_STATUS ='O';