APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_VALUE_SETS_V

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

1857: -- Value set name is expected in ATTR_DISP_VALUE column, we convert it to --
1858: -- value set id and store it in ATTR_VALUE_NUM col. --
1859: -------------------------------------------------------------------------------
1860: UPDATE EGO_ITM_USR_ATTR_INTRFC INTF
1861: SET ATTR_VALUE_NUM = (SELECT VALUE_SET_ID FROM EGO_VALUE_SETS_V VS
1862: WHERE VALUE_SET_NAME = INTF.ATTR_DISP_VALUE)
1863: WHERE INTF.DATA_SET_ID = p_data_set_id
1864: AND INTF.PROCESS_STATUS = G_PS_STYLE_VARIANT_IN_PROCESS
1865: AND INTF.ATTR_DISP_VALUE IS NOT NULL;