APPS.AMS_TCOP_PREVIEW dependencies on AMS_CAMPAIGNS_VL

Line 2201: AMS_ACT_LISTS ACT_LIST,ams_campaigns_vl CAMP

2197: CURSOR C_GET_SCHEDULE_DETAILS
2198: IS
2199: SELECT CSCH.SCHEDULE_ID,CSCH.START_DATE_TIME,CSCH.ACTIVITY_ID,CAMP.ACTUAL_EXEC_END_DATE
2200: FROM AMS_CAMPAIGN_SCHEDULES_B CSCH,
2201: AMS_ACT_LISTS ACT_LIST,ams_campaigns_vl CAMP
2202: WHERE ACT_LIST.LIST_HEADER_ID = p_list_header_id
2203: AND CSCH.SCHEDULE_ID = ACT_LIST.LIST_USED_BY_ID
2204: AND ACT_LIST.LIST_USED_BY = 'CSCH'
2205: AND ACT_LIST.LIST_ACT_TYPE='TARGET'