DBA Data[Home] [Help]

APPS.IEM_MAILITEM_PUB dependencies on IEM_CLASSIFICATIONS

Line 1427: l_top_intent iem_classifications.classification%type;

1423: l_ret_status varchar2(10);
1424: l_msg_data varchar2(1000);
1425: l_msg_count number;
1426: l_out_message_id number;
1427: l_top_intent iem_classifications.classification%type;
1428: insert_arch_dtl_error EXCEPTION;
1429: cursor c1 is select a.classification,b.score from
1430: iem_classifications a,iem_email_classifications b
1431: where b.message_id=p_message_id

Line 1430: iem_classifications a,iem_email_classifications b

1426: l_out_message_id number;
1427: l_top_intent iem_classifications.classification%type;
1428: insert_arch_dtl_error EXCEPTION;
1429: cursor c1 is select a.classification,b.score from
1430: iem_classifications a,iem_email_classifications b
1431: where b.message_id=p_message_id
1432: and a.classification_id=b.classification_id
1433: order by score asc;
1434: l_api_version_number number:=1.0;