APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_ACCOUNT_CATEGORIES

Line 4421: cursor c1 is select category_id from iem_account_categories

4417: l_sms_string varchar2(255);
4418: l_sms_count number;
4419: l_counter number:=1;
4420: g_app_id number;
4421: cursor c1 is select category_id from iem_account_categories
4422: where email_account_id=l_email_account_id;
4423: cursor c2 is
4424: select keyword,weight from iem_intent_dtls where intent_id=l_classification_id
4425: and query_response='R';