APPS.ICX_POR_EXTRACTOR dependencies on ICX_CAT_ITEMS_B

Line 307: update icx_cat_items_b it

303: -- prices are available.
304:
305: xErrLoc := 470;
306:
307: update icx_cat_items_b it
308: SET EXTRACTOR_UPDATED_FLAG = 'N'
309: WHERE NOT EXISTS
310: (SELECT 1 FROM icx_cat_item_prices itp
311: WHERE PRICE_TYPE NOT in ( 'BULKLOAD' , 'CONTRACT')