APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_INTENTS

Line 159: iem_intents a,iem_email_classifications b

155: -- Introduce additional key Intent String
156: l_top_intent varchar2(50);
157: l_top_score number;
158: cursor c_intent is select a.intent,b.score from
159: iem_intents a,iem_email_classifications b
160: where b.message_id=l_message_id
161: and a.intent_id=b.classification_id;
162: l_intent_str varchar2(700);
163: l_header_rec iem_ms_base_headers%rowtype;

Line 3731: from iem_intents

3727: l_gclassid:=x.classification_id;
3728: g_topscore:=x.score;
3729: BEGIN
3730: select intent into g_topclass
3731: from iem_intents
3732: where intent_id=l_gclassid;
3733: EXCEPTION WHEN OTHERS THEN
3734: null;
3735: END;

Line 3796: iem_intents a,iem_email_classifications b

3792: l_message_id number;
3793: l_top_intent varchar2(50);
3794: l_top_score number;
3795: cursor c_intent is select a.intent,b.score from
3796: iem_intents a,iem_email_classifications b
3797: where b.message_id=l_message_id
3798: and a.intent_id=b.classification_id;
3799: g_statement_log boolean; -- Statement Level Logging
3800: l_intent_str varchar2(700);