APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_ACCOUNT_CATEGORIES

Line 5516: cursor c1 is select category_id from iem_account_categories

5512: l_sms_string varchar2(255);
5513: l_sms_count number;
5514: l_counter number:=1;
5515: g_app_id number;
5516: cursor c1 is select category_id from iem_account_categories
5517: where email_account_id=l_email_account_id;
5518: cursor c2 is
5519: select keyword,weight from iem_intent_dtls where intent_id=l_classification_id
5520: and query_response='R';