APPS.IEU_TASKS_USERHOOKS dependencies on IEU_UWQM_WS_ASSCT_PROPS

Line 173: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

169: BEGIN
170:
171: SELECT a.ws_id, b.ws_code
172: INTO l_association_ws_id, l_association_ws_code
173: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
174: WHERE child_ws_id = l_ws_id1
175: AND parent_ws_id = l_ws_id2
176: AND a.ws_id = b.ws_id
177: --AND nvl(b.not_valid_flag,'N') = 'N';

Line 223: FROM ieu_uwqm_ws_assct_props ws_b

219: BEGIN
220:
221: SELECT ws_b.tasks_rules_function
222: INTO l_tasks_rules_func
223: FROM ieu_uwqm_ws_assct_props ws_b
224: WHERE ws_b.ws_id = l_association_ws_id;
225:
226: EXCEPTION
227: WHEN OTHERS THEN

Line 576: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

572: BEGIN
573:
574: SELECT a.ws_id, b.ws_code
575: INTO l_association_ws_id, l_association_ws_code
576: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
577: WHERE child_ws_id = l_ws_id1
578: AND parent_ws_id = l_ws_id2
579: AND a.ws_id = b.ws_id
580: --AND nvl(b.not_valid_flag,'N') = 'N';

Line 624: FROM ieu_uwqm_ws_assct_props ws_b

620: BEGIN
621:
622: SELECT ws_b.tasks_rules_function
623: INTO l_tasks_rules_func
624: FROM ieu_uwqm_ws_assct_props ws_b
625: WHERE ws_b.ws_id = l_association_ws_id;
626:
627: EXCEPTION
628: WHEN OTHERS THEN

Line 1059: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

1055: BEGIN
1056:
1057: SELECT a.ws_id, b.ws_code
1058: INTO l_association_ws_id, l_association_ws_code
1059: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
1060: WHERE child_ws_id = l_ws_id1
1061: AND parent_ws_id = l_ws_id2
1062: AND a.ws_id = b.ws_id
1063: --AND nvl(b.not_valid_flag,'N') = 'N';

Line 1107: FROM ieu_uwqm_ws_assct_props ws_b

1103: BEGIN
1104:
1105: SELECT ws_b.tasks_rules_function
1106: INTO l_tasks_rules_func
1107: FROM ieu_uwqm_ws_assct_props ws_b
1108: WHERE ws_b.ws_id = l_association_ws_id;
1109:
1110: EXCEPTION
1111: WHEN OTHERS THEN

Line 1444: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

1440: BEGIN
1441:
1442: SELECT a.ws_id, b.ws_code
1443: INTO l_association_ws_id, l_association_ws_code
1444: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
1445: WHERE child_ws_id = l_ws_id1
1446: AND parent_ws_id = l_ws_id2
1447: AND a.ws_id = b.ws_id
1448: -- AND nvl(b.not_valid_flag,'N') = 'N';

Line 1493: FROM ieu_uwqm_ws_assct_props ws_b

1489: BEGIN
1490:
1491: SELECT ws_b.tasks_rules_function
1492: INTO l_tasks_rules_func
1493: FROM ieu_uwqm_ws_assct_props ws_b
1494: WHERE ws_b.ws_id = l_association_ws_id;
1495:
1496: EXCEPTION
1497: WHEN OTHERS THEN

Line 2227: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

2223: BEGIN
2224:
2225: SELECT a.ws_id, b.ws_code
2226: INTO l_association_ws_id, l_association_ws_code
2227: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
2228: WHERE child_ws_id = l_ws_id1
2229: AND parent_ws_id = l_ws_id2
2230: AND a.ws_id = b.ws_id
2231: --AND nvl(b.not_valid_flag,'N') = 'N';

Line 2276: FROM ieu_uwqm_ws_assct_props ws_b

2272: BEGIN
2273:
2274: SELECT ws_b.tasks_rules_function
2275: INTO l_tasks_rules_func
2276: FROM ieu_uwqm_ws_assct_props ws_b
2277: WHERE ws_b.ws_id = l_association_ws_id;
2278:
2279: EXCEPTION
2280: WHEN OTHERS THEN

Line 2963: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b

2959: BEGIN
2960:
2961: SELECT a.ws_id, b.ws_code
2962: INTO l_association_ws_id, l_association_ws_code
2963: FROM ieu_uwqm_ws_assct_props a, ieu_uwqm_work_sources_b b
2964: WHERE child_ws_id = l_ws_id1
2965: AND parent_ws_id = l_ws_id2
2966: AND a.ws_id = b.ws_id
2967: --AND nvl(b.not_valid_flag,'N') = 'N';

Line 3012: FROM ieu_uwqm_ws_assct_props ws_b

3008: BEGIN
3009:
3010: SELECT ws_b.tasks_rules_function
3011: INTO l_tasks_rules_func
3012: FROM ieu_uwqm_ws_assct_props ws_b
3013: WHERE ws_b.ws_id = l_association_ws_id;
3014:
3015: EXCEPTION
3016: WHEN OTHERS THEN