APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_SHOP_STORES_S

Line 2721: SELECT store_id, ICX_CAT_SHOP_STORES_S.NEXTVAL

2717:
2718: l_err_loc := 0;
2719:
2720: -- select all the old stores (minus the seeded ones) and new store IDs
2721: SELECT store_id, ICX_CAT_SHOP_STORES_S.NEXTVAL
2722: BULK COLLECT INTO l_old_store_ids, l_r12_store_ids
2723: FROM icx_cat_stores_b
2724: WHERE store_id NOT IN (0, 10000000);
2725: