APPS.IEB_SYNC_SERVER dependencies on IEB_WB_SVC_CAT_RULES

Line 171: DELETE FROM ieb_wb_svc_cat_rules WHERE wbsc_wbsc_id NOT IN

167: -- default service categories here; but no problem, may be the
168: -- data is messed up
169: else
170: -- delete any service category rules for the deleted service categories
171: DELETE FROM ieb_wb_svc_cat_rules WHERE wbsc_wbsc_id NOT IN
172: (SELECT wbsc_id FROM ieb_wb_svc_cats);
173:
174: IF (sql%notfound) then
175: null; -- is ok if no data found here