APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_INTENTS

Line 187: iem_intents a,iem_email_classifications b

183: l_top_score number;
184:
185: -- sardas ,modified query for intent issue fix bug#13946049
186: cursor c_intent is select a.intent,b.score from
187: iem_intents a,iem_email_classifications b
188: where b.message_id=l_message_id
189: and a.intent_id=b.classification_id
190: order by b.score desc;
191:

Line 4826: from iem_intents

4822: l_gclassid:=x.classification_id;
4823: g_topscore:=x.score;
4824: BEGIN
4825: select intent into g_topclass
4826: from iem_intents
4827: where intent_id=l_gclassid;
4828: EXCEPTION WHEN OTHERS THEN
4829: null;
4830: END;

Line 4891: iem_intents a,iem_email_classifications b

4887: l_message_id number;
4888: l_top_intent varchar2(50);
4889: l_top_score number;
4890: cursor c_intent is select a.intent,b.score from
4891: iem_intents a,iem_email_classifications b
4892: where b.message_id=l_message_id
4893: and a.intent_id=b.classification_id;
4894: g_statement_log boolean; -- Statement Level Logging
4895: l_intent_str varchar2(700);