APPS.IEO_SUM_AVB_RECORD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

	select sum(A.REC_AVAILABLE) into ieototal
	from IEO_CP_LIST_STATS_ALL A, IEO_CP_SVC_LISTS_ALL B
	where	A.LIST_SRV_NAME = LIST_SRV_NAME_Value
	    and A.LIST_SRV_NAME = B.LIST_SRV_NAME
	    and A.LIST_NAME = B.LIST_NAME
	    and B.LIST_STATUS ='O';

Line: 32

	select LIST_SRV_NAME from IEO_CP_SERVICES_ALL
	where CAMPAIGN_LIST_ID in
		(select DISTINCT(A.LIST_HEADER_ID)
		from 	AMS_LIST_HEADERS_ALL A,
			AMS_CAMPAIGN_SCHEDULES B
		where	A.LIST_USED_BY_ID = B.CAMPAIGN_SCHEDULE_ID
			and B.CAMPAIGN_ID  = CAMPAIGN_ID_Value);