APPS.IEO_SUM_AVB_RECORD dependencies on IEO_CP_SERVICES_ALL

Line 32: select LIST_SRV_NAME from IEO_CP_SERVICES_ALL

28: RETURN NUMBER
29: IS
30: amstotal NUMBER(15):= 0;
31: CURSOR c_srvname IS
32: select LIST_SRV_NAME from IEO_CP_SERVICES_ALL
33: where CAMPAIGN_LIST_ID in
34: (select DISTINCT(A.LIST_HEADER_ID)
35: from AMS_LIST_HEADERS_ALL A,
36: AMS_CAMPAIGN_SCHEDULES B