APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_ACCOUNT_INTENTS

Line 3618: from iem_intent_dtls a,iem_account_intents b

3614: l_theme_buf IEM_TEXT_PVT.theme_tAble;
3615: l_token_buf IEM_TEXT_PVT.token_table;
3616: cursor c1 is
3617: SELECT a.intent_id, a.keyword,a.weight
3618: from iem_intent_dtls a,iem_account_intents b
3619: WHERE b.email_account_id=l_email_account_id
3620: AND a.intent_id=b.intent_id
3621: AND QUERY_RESPONSE='Q'
3622: and weight>0