APPS.IEO_SUM_AVB_RECORD dependencies on AMS_LIST_HEADERS_ALL

Line 35: from AMS_LIST_HEADERS_ALL A,

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
37: where A.LIST_USED_BY_ID = B.CAMPAIGN_SCHEDULE_ID
38: and B.CAMPAIGN_ID = CAMPAIGN_ID_Value);
39: