APPS.IEC_VALIDATE_PVT dependencies on AMS_ACT_LISTS

Line 9770: FROM AMS_ACT_LISTS A, AMS_CAMPAIGN_SCHEDULES_B B

9766: EXECUTE IMMEDIATE
9767:
9768: 'SELECT B.CAMPAIGN_ID
9769:
9770: FROM AMS_ACT_LISTS A, AMS_CAMPAIGN_SCHEDULES_B B
9771:
9772: WHERE A.LIST_HEADER_ID = :list_id
9773:
9774: AND A.LIST_USED_BY = ''CSCH''

Line 9864: FROM AMS_ACT_LISTS A, AMS_CAMPAIGN_SCHEDULES_B B

9860: EXECUTE IMMEDIATE
9861:
9862: 'SELECT B.SOURCE_CODE
9863:
9864: FROM AMS_ACT_LISTS A, AMS_CAMPAIGN_SCHEDULES_B B
9865:
9866: WHERE A.LIST_USED_BY_ID = B.SCHEDULE_ID
9867:
9868: AND A.LIST_HEADER_ID = :list_id'

Line 12941: SELECT LIST_USED_BY_ID into l_schedule_id FROM AMS_ACT_LISTS

12937: -- Must do this before move non-duplicate records b/c they will become
12938:
12939: -- duplicates after the move
12940:
12941: SELECT LIST_USED_BY_ID into l_schedule_id FROM AMS_ACT_LISTS
12942: WHERE LIST_HEADER_ID = p_to_list_id AND LIST_ACT_TYPE = 'TARGET';
12943:
12944: Log_DuplicateEntries
12945: