APPS.AMS_TCOP_PREVIEW dependencies on AMS_ACT_LISTS

Line 406: AMS_ACT_LISTS ACT_LIST,

402: CURSOR C_GET_SCHEDULE_IN_PIPELINE
403: IS
404: SELECT CSCH.SCHEDULE_ID,CSCH.ACTIVITY_ID,CSCH.START_DATE_TIME
405: FROM AMS_CAMPAIGN_SCHEDULES_B CSCH,
406: AMS_ACT_LISTS ACT_LIST,
407: AMS_LIST_HEADERS_ALL LIST_HEADER
408: WHERE CSCH.START_DATE_TIME BETWEEN
409: p_preview_start_date AND p_preview_end_date
410: AND CSCH.STATUS_CODE in ('AVAILABLE','ACTIVE')

Line 434: AMS_ACT_LISTS ACT_LIST,

430: CURSOR C_GET_SCHEDULE_IN_PIPELINE
431: IS
432: SELECT /*+ leading(ACT_LIST) */ CSCH.SCHEDULE_ID,CSCH.ACTIVITY_ID,CSCH.START_DATE_TIME
433: FROM AMS_CAMPAIGN_SCHEDULES_B CSCH,
434: AMS_ACT_LISTS ACT_LIST,
435: AMS_LIST_HEADERS_ALL LIST_HEADER
436: WHERE TRUNC(CSCH.START_DATE_TIME) BETWEEN
437: p_preview_start_date AND p_preview_end_date
438: AND CSCH.STATUS_CODE in ('AVAILABLE','ACTIVE')

Line 464: ,AMS_ACT_LISTS ACT_LIST

460: SELECT LIST_ENTRY1.PARTY_ID
461: FROM AMS_LIST_ENTRIES LIST_ENTRY1
462: ,AMS_LIST_ENTRIES LIST_ENTRY2
463: ,AMS_CAMPAIGN_SCHEDULES_B CSCH
464: ,AMS_ACT_LISTS ACT_LIST
465: ,AMS_LIST_HEADERS_ALL LIST_HEADER
466: WHERE LIST_ENTRY1.LIST_HEADER_ID = p_list_header_id
467: AND LIST_ENTRY2.PARTY_ID = LIST_ENTRY1.PARTY_ID
468: AND LIST_ENTRY2.LIST_HEADER_ID = LIST_HEADER.LIST_HEADER_ID

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'