APPS.IEM_MIGRATION_PVT dependencies on IEM_MS_BASE_HEADERS_S1

Line 327: select iem_ms_base_headers_s1.nextval into l_message_id from dual;

323: --these values due to data issue where we cant find a valid media_id
324: --RAISE POST_CREATION_DATE_EXCEP;
325: END;
326: END IF;
327: select iem_ms_base_headers_s1.nextval into l_message_id from dual;
328:
329: insert into iem_arch_msgdtls
330: (MESSAGE_ID ,
331: EMAIL_ACCOUNT_ID ,

Line 1318: select iem_ms_base_headers_s1.nextval into l_id1 from dual;

1314: -- record in iem_post_mdts.otherwise the loop will be never
1315: -- ending
1316: select nvl(max(message_id),0) into l_id from iem_post_mdts;
1317: LOOP
1318: select iem_ms_base_headers_s1.nextval into l_id1 from dual;
1319: exit when l_id1>l_id;
1320: END LOOP;
1321: end if;
1322: else