APPS.IEM_KNOWLEDGEBASE_PUB dependencies on IEM_RT_PROC_EMAILS

Line 466: from iem_rt_proc_emails where message_id=p_message_id;

462: IF l_doc_count=0 then -- No document has retrieved .
463:
464: select rule_id
465: into l_rule_id
466: from iem_rt_proc_emails where message_id=p_message_id;
467: BEGIN
468: select action into l_action from
469: iem_actions where emailproc_id=l_rule_id;
470: l_search_type:=substr(l_action,15,length(l_action));