APPS.IEM_THEMES_PVT dependencies on IEM_ACCOUNT_INTENT_DOCS

Line 736: delete from iem_account_intent_docs where account_intent_doc_id

732: WHERE theme_id = p_thes_ids_tbl(i);
733: -- Score Readjustment using noise reduction algorithim
734: delete from iem_theme_docs where theme_id not in
735: (select theme_id from iem_themes);
736: delete from iem_account_intent_docs where account_intent_doc_id
737: not in (select account_intent_doc_id from iem_theme_docs);
738: select email_account_id into l_email_account_id
739: from iem_classifications
740: where classification_id=l_class_id;

Line 1073: from iem_account_intent_docs

1069:
1070: -- select nvl(sum(document_no),0)
1071: select count(*)
1072: into l_N
1073: from iem_account_intent_docs
1074: where email_account_id=p_email_account_id
1075: and query_response=p_query_response;
1076:
1077: for v1 in c_theme LOOP

Line 1084: from iem_account_intent_docs

1080:
1081: -- select nvl(sum(document_no),0)
1082: select count(*)
1083: into l_R
1084: from iem_account_intent_docs
1085: where classification_id=v1.classification_id
1086: and query_response=v1.query_response;
1087:
1088: -- no of document matching the theme in the system