APPS.IEU_WR_CON_PVT dependencies on IEU_UWQM_WORK_SOURCES_B

Line 180: FROM IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A

176:
177: SELECT WS_B.WS_ID, WS_B.WS_TYPE, WS_A.DIST_ST_BASED_ON_PARENT_FLAG,
178: WS_A.PARENT_WS_ID, WS_A.CHILD_WS_ID
179: INTO l_ws_id, l_ws_type, l_dist_st_based_on_parent, l_parent_ws_id, l_child_ws_id
180: FROM IEU_UWQM_WORK_SOURCES_B WS_B, IEU_UWQM_WS_ASSCT_PROPS WS_A
181: WHERE ws_b.ws_code = p_ws_code
182: AND ws_b.not_valid_flag = 'N'
183: AND ws_b.ws_id = ws_a.ws_id(+);
184:

Line 262: from ieu_uwqm_work_sources_b

258: RETCODE := 2;
259: BEGIN
260: select ws_code
261: into l_parent_ws_code
262: from ieu_uwqm_work_sources_b
263: where ws_id = l_parent_ws_id;
264: EXCEPTION
265: WHEN OTHERS THEN
266: l_parent_ws_code := null;