APPS.IEM_MIGRATION_PVT dependencies on IEM_RT_INTERACTIONS

Line 127: from iem_rt_media_items rtm, iem_rt_interactions rti

123: select count(a.rt_media_item_id)
124: into l_total_count
125: from iem_rt_media_items a, iem_msg_parts part
126: where a.rt_interaction_id in (select rtm.rt_interaction_id
127: from iem_rt_media_items rtm, iem_rt_interactions rti
128: where rtm.message_id in (select message_id from iem_post_mdts
129: where email_account_id = l_email_account_id and agent_id = v3.resource_id)
130: and rtm.email_type ='I' and rtm.rt_interaction_id = rti.rt_interaction_id
131: and rti.expire = 'N') and a.email_type = 'O' and a.folder_uid > 0

Line 1267: from iem_rt_interactions where expire <> 'N' AND expire <> 'Y';

1263: l_error_message:='Please Clean up the Preprocessing Queue Before starting Migration ';
1264: raise WORKER_NOT_SUBMITTED;
1265: end if;
1266: select count(rt_interaction_id) into l_mig_count
1267: from iem_rt_interactions where expire <> 'N' AND expire <> 'Y';
1268: if l_mig_count>0 then
1269: l_error_message:='Please Clean up the Outbox Processing Queue Before starting Migration ';
1270: raise WORKER_NOT_SUBMITTED;
1271: end if;