APPS.IEU_WR_CON_PVT dependencies on IEU_UWQM_WS_ASSCT_PROPS

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 506: FROM IEU_UWQM_WS_ASSCT_PROPS WS_A

502: BEGIN
503: l_child_ws_id := null;
504: SELECT WS_A.WS_ASSOCIATION_PROP_ID,WS_A.WS_ID
505: INTO l_assct_ws_id,l_child_ws_id
506: FROM IEU_UWQM_WS_ASSCT_PROPS WS_A
507: WHERE parent_ws_id = l_ws_id;
508:
509: EXCEPTION
510: WHEN OTHERS THEN