APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_VALUE_SETS_V

Line 2295: SET ATTR_VALUE_NUM = (SELECT VALUE_SET_ID FROM EGO_VALUE_SETS_V VS

2291: -- Value set name is expected in ATTR_DISP_VALUE column, we convert it to --
2292: -- value set id and store it in ATTR_VALUE_NUM col. --
2293: -------------------------------------------------------------------------------
2294: UPDATE EGO_ITM_USR_ATTR_INTRFC INTF
2295: SET ATTR_VALUE_NUM = (SELECT VALUE_SET_ID FROM EGO_VALUE_SETS_V VS
2296: WHERE VALUE_SET_NAME = INTF.ATTR_DISP_VALUE)
2297: WHERE INTF.DATA_SET_ID = p_data_set_id
2298: AND INTF.PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
2299: AND INTF.ATTR_DISP_VALUE IS NOT NULL;