APPS.IEM_MIGRATION_PVT dependencies on IEM_AGENTS_S1

Line 1806: select iem_agents_s1.nextval into l_val from dual;

1802: -- Reset the Sequence to have highest agent id
1803:
1804: select nvl(max(agent_id),0) into l_max_id from iem_agents;
1805: LOOP
1806: select iem_agents_s1.nextval into l_val from dual;
1807: exit when l_val>l_max_id;
1808: END LOOP;
1809:
1810: -- Reset the Sequence to have highest intent id