DBA Data[Home] [Help]

APPS.IEC_VALIDATE_PVT dependencies on AMS_ACT_LISTS

Line 9748: FROM AMS_ACT_LISTS A, AMS_CAMPAIGN_SCHEDULES_B B

9744: EXECUTE IMMEDIATE
9745:
9746: 'SELECT B.CAMPAIGN_ID
9747:
9748: FROM AMS_ACT_LISTS A, AMS_CAMPAIGN_SCHEDULES_B B
9749:
9750: WHERE A.LIST_HEADER_ID = :list_id
9751:
9752: AND A.LIST_USED_BY = ''CSCH''

Line 9842: FROM AMS_ACT_LISTS A, AMS_CAMPAIGN_SCHEDULES_B B

9838: EXECUTE IMMEDIATE
9839:
9840: 'SELECT B.SOURCE_CODE
9841:
9842: FROM AMS_ACT_LISTS A, AMS_CAMPAIGN_SCHEDULES_B B
9843:
9844: WHERE A.LIST_USED_BY_ID = B.SCHEDULE_ID
9845:
9846: AND A.LIST_HEADER_ID = :list_id'

Line 12919: SELECT LIST_USED_BY_ID into l_schedule_id FROM AMS_ACT_LISTS

12915: -- Must do this before move non-duplicate records b/c they will become
12916:
12917: -- duplicates after the move
12918:
12919: SELECT LIST_USED_BY_ID into l_schedule_id FROM AMS_ACT_LISTS
12920: WHERE LIST_HEADER_ID = p_to_list_id AND LIST_ACT_TYPE = 'TARGET';
12921:
12922: Log_DuplicateEntries
12923: