APPS.IEM_MIGRATION_PVT dependencies on IEM_MS_BASE_HEADERS_S1

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

253: l_media_id:=v1.ih_media_item_id;
254: select creation_date into l_received_Date from jtf_ih_media_items
255: where media_id=l_media_id;
256: l_received_date:=sysdate;
257: select iem_ms_base_headers_s1.nextval into l_message_id from dual;
258:
259: insert into iem_arch_msgdtls
260: (MESSAGE_ID ,
261: EMAIL_ACCOUNT_ID ,

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

1130: -- record in iem_post_mdts.otherwise the loop will be never
1131: -- ending
1132: select nvl(max(message_id),0) into l_id from iem_post_mdts;
1133: LOOP
1134: select iem_ms_base_headers_s1.nextval into l_id1 from dual;
1135: exit when l_id1>l_id;
1136: END LOOP;
1137: end if;
1138: else