APPS.IEM_CLIENTLAUNCH_PUB dependencies on IEM_RT_PROC_EMAILS

Line 93: from iem_rt_proc_emails where message_id = l_msg_id;

89: select route_classification_id into l_classification_id from iem_account_route_class
90: where account_route_class_id = l_acct_rt_class_id;
91: elsif l_launched_node = 'MESSAGE_ID' then
92: select rt_classification_id,customer_id,nvl(contact_id,-1) into l_classification_id,l_cust_id,l_contact_id
93: from iem_rt_proc_emails where message_id = l_msg_id;
94:
95: begin
96: select incident_number into l_sr_number from cs_incidents_all_b
97: where incident_id=(select value from iem_encrypted_tags tags,

Line 217: from iem_route_classifications a, iem_rt_proc_emails b

213:
214: select route_classification_id, name
215: into l_classification_id, l_class_name
216: --from iem_route_classifications a, iem_post_mdts b
217: from iem_route_classifications a, iem_rt_proc_emails b
218: where a.route_classification_id = b.rt_classification_id
219: and b.message_id = l_msg_id;
220:
221: select rt_media_item_id