DBA Data[Home] [Help]

APPS.IEM_MAILITEM_PUB dependencies on IEM_CLASSIFICATIONS

Line 1613: l_top_intent iem_classifications.classification%type;

1609: l_ret_status varchar2(10);
1610: l_msg_data varchar2(1000);
1611: l_msg_count number;
1612: l_out_message_id number;
1613: l_top_intent iem_classifications.classification%type;
1614: insert_arch_dtl_error EXCEPTION;
1615: cursor c1 is select a.classification,b.score from
1616: iem_classifications a,iem_email_classifications b
1617: where b.message_id=p_message_id

Line 1616: iem_classifications a,iem_email_classifications b

1612: l_out_message_id number;
1613: l_top_intent iem_classifications.classification%type;
1614: insert_arch_dtl_error EXCEPTION;
1615: cursor c1 is select a.classification,b.score from
1616: iem_classifications a,iem_email_classifications b
1617: where b.message_id=p_message_id
1618: and a.classification_id=b.classification_id
1619: order by score asc;
1620: l_api_version_number number:=1.0;