APPS.IEU_TASKS_WR_MIG_PVT dependencies on IEU_UWQM_WORK_SOURCES_B

Line 36: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;

32: -- Reqd for Distribution Rules
33: l_ws_id1 NUMBER;
34: l_ws_id2 NUMBER := null;
35: l_association_ws_id NUMBER;
36: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
37: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
38:
39: l_uwqm_count number := 0;
40: l_uwqm_open_count number := 0;

Line 37: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;

33: l_ws_id1 NUMBER;
34: l_ws_id2 NUMBER := null;
35: l_association_ws_id NUMBER;
36: l_dist_from IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_FROM%TYPE;
37: l_dist_to IEU_UWQM_WORK_SOURCES_B.DISTRIBUTE_TO%TYPE;
38:
39: l_uwqm_count number := 0;
40: l_uwqm_open_count number := 0;
41: l_task_open_count number := 0;

Line 226: from ieu_uwqm_work_sources_b

222: l_object_code VARCHAR2(10);
223:
224: cursor c1(p_child_ws_id IN NUMBER) is
225: select ''''||object_code||'''' object_code
226: from ieu_uwqm_work_sources_b
227: where ws_id in ( select assct_props.parent_ws_id
228: from ieu_uwqm_work_sources_b ws, ieu_uwqm_ws_assct_props assct_props
229: where ws.ws_id = assct_props.ws_id
230: and assct_props.child_ws_id = p_child_ws_id

Line 228: from ieu_uwqm_work_sources_b ws, ieu_uwqm_ws_assct_props assct_props

224: cursor c1(p_child_ws_id IN NUMBER) is
225: select ''''||object_code||'''' object_code
226: from ieu_uwqm_work_sources_b
227: where ws_id in ( select assct_props.parent_ws_id
228: from ieu_uwqm_work_sources_b ws, ieu_uwqm_ws_assct_props assct_props
229: where ws.ws_id = assct_props.ws_id
230: and assct_props.child_ws_id = p_child_ws_id
231: and nvl(ws.not_valid_flag,'N') = 'N');
232:

Line 304: from ieu_uwqm_work_sources_b

300: l_object_code := 'TASK';
301: l_not_valid_flag := 'N';
302: select ws_id
303: into l_ws_id
304: from ieu_uwqm_work_sources_b
305: where object_code = l_object_code
306: and nvl(not_valid_flag, 'N') = l_not_valid_flag;
307: exception
308: when others then

Line 323: from ieu_uwqm_work_sources_b ws, ieu_uwqm_ws_assct_props assct_props

319: l_ws_exists := 'N';
320:
321: select count(*)
322: into l_assct_ws_cnt
323: from ieu_uwqm_work_sources_b ws, ieu_uwqm_ws_assct_props assct_props
324: where ws.ws_id = assct_props.ws_id
325: and assct_props.child_ws_id = l_ws_id
326: and nvl(ws.not_valid_flag,'N') = 'N';
327: