Line 1530: cursor c1 is select * from iem_themes where classification_id=l_intent_id
1526: select distinct a.classification_id,a.classification from
1527: iem_classifications a
1528: where a.email_account_id=l_email_account_id;
1529: 1530: cursor c1 is select * from iem_themes where classification_id=l_intent_id 1531: and score>0;
1532:
1533: l_template_profile number;
1534: l_sender_profile varchar2(100);