APPS.IEM_KNOWLEDGEBASE_PUB dependencies on IEM_EMAIL_CATEGORY_MAPS

Line 127: SELECT kb_category_id FROM IEM_EMAIL_CATEGORY_MAPS

123: WHERE LEVEL=p_LEVEL
124: CONNECT BY PRIOR kb_category_id=kb_parent_category_id
125: START WITH kb_category_id= p_cat_id;
126: CURSOR kb_catid_csr is
127: SELECT kb_category_id FROM IEM_EMAIL_CATEGORY_MAPS
128: WHERE EMAIL_ACCOUNT_ID=p_EMAIL_ACCOUNT_ID;
129:
130: l_api_name VARCHAR2(255):='Get_KBCategories';
131: l_api_version_number NUMBER:=1.0;