APPS.IEM_CLASSIFICATIONS_PVT dependencies on IEM_THEME_DOCS

Line 894: delete from iem_theme_docs

890: END LOOP;
891: delete from iem_account_intent_docs
892: where classification_id not in
893: (select classification_id from iem_classifications);
894: delete from iem_theme_docs
895: where account_intent_doc_id not in
896: (select account_intent_doc_id from iem_account_intent_docs);
897: iem_themes_pvt.calculate_weight (l_email_account_id,
898: 'Q' ,