APPS.IEC_AGT_ASSN_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

   	l_assignment_stmt := 	' SELECT ' ||
													'	astcamp.resource_id RESOURCE_ID, ' ||
													'	amssched.campaign_id CAMPAIGN_ID, ' ||
													'	astcamp.campaign_id SCHEDULE_ID ' ||
													' FROM ' ||
													'	AMS_CAMPAIGN_SCHEDULES_B amssched, ' ||
													'	AST_RS_CAMPAIGNS astcamp ' ||
													' WHERE ' ||
													'	astcamp.campaign_id = amssched.schedule_id ' ||
													' UNION ' ||
													' SELECT ' ||
													'	grpmem.resource_id RESOURCE_ID, ' ||
													'	amssched.campaign_id CAMPAIGN_ID, ' ||
													'	grpcamp.campaign_id SCHEDULE_ID ' ||
													' FROM ' ||
													'	AMS_CAMPAIGN_SCHEDULES_B amssched, ' ||
													'	AST_GRP_CAMPAIGNS grpcamp, ' ||
													'	JTF_RS_GROUP_MEMBERS grpmem, ' ||
													'	JTF_RS_GROUPS_DENORM grpdenorm ' ||
													' WHERE ' ||
													'	grpmem.group_id = grpdenorm.group_id ' ||
													'	and grpcamp.group_id = grpdenorm.parent_group_id ' ||
													'	and grpcamp.campaign_id = amssched.schedule_id ';

Line: 57

   	l_assignment_stmt := ' SELECT RESOURCE_ID, IEU_PARAM_PK_VALUE CAMPAIGN_ID, QUEUE_COUNT ' ||
   						 ' FROM IEC_ADV_OUTB_WORKNODE_UWQ_V ';

Line: 80

   	l_assignment_stmt := ' SELECT RESOURCE_ID, IEU_PARAM_PK_VALUE CAMPAIGN_ID, QUEUE_COUNT ' ||
   						 ' FROM IEC_ADV_OUTB_WORKNODE_UWQ_V ' ||
   						 ' WHERE RESOURCE_ID = :1 ';

Line: 103

   	l_cpn_count_stmt := 'SELECT	CAMPAIGN_ID, CAMPAIGN_NAME, SUM(QUEUE_COUNT) ' ||
   						' FROM ( ' ||
   						' 		 SELECT CAMPAIGN_ID, CAMPAIGN_NAME, SCHEDULE_ID, QUEUE_COUNT ' ||
   						' 		 FROM IEC_AGENT_WORK_ASSIGNMENTS_V ' ||
   						' 		 UNION	' ||
   						' 		 SELECT CAMPAIGN_ID, CAMPAIGN_NAME, SCHEDULE_ID, QUEUE_COUNT ' ||
   						'		 FROM IEC_GROUP_WORK_ASSIGNMENTS_V ) ' ||
   						' GROUP BY CAMPAIGN_ID, CAMPAIGN_NAME';