DBA Data[Home] [Help]

APPS.EGO_PUB_WS_VS dependencies on EGO_VALUE_SETS_V

Line 150: FROM EGO_VALUE_SETS_V evsv

146: IF l_vs_id IS NOT NULL THEN
147: BEGIN
148: SELECT evsv.value_set_name
149: INTO x_vs_name
150: FROM EGO_VALUE_SETS_V evsv
151: WHERE evsv.value_set_id = to_number(l_vs_id);
152:
153: x_vs_id := l_vs_id;
154: debug(1, l_proc_name||'id is valid');

Line 180: FROM EGO_VALUE_SETS_V evsv

176: <>
177: BEGIN
178: SELECT evsv.value_set_id
179: INTO l_vs_id
180: FROM EGO_VALUE_SETS_V evsv
181: WHERE evsv.value_set_name = l_vs_name;
182: x_vs_id := l_vs_id;
183: x_vs_name := l_vs_name;
184: EXCEPTION