[Home] [Help]
4175: BEGIN
4176:
4177: SELECT PROJ_ELEMENT_ID, CBS_ELEMENT_ID
4178: INTO l_actual_task_id, l_cbs_element_id
4179: FROM PA_ALTERNATE_TASKS
4180: WHERE alt_task_id = l_task_id_tbl(i);
4181:
4182: EXCEPTION
4183: WHEN OTHERS THEN
6408: BEGIN
6409:
6410: SELECT PROJ_ELEMENT_ID, CBS_ELEMENT_ID
6411: INTO l_actual_task_id, l_cbs_element_id
6412: FROM PA_ALTERNATE_TASKS
6413: WHERE alt_task_id = l_task_id_tbl(i);
6414:
6415: EXCEPTION
6416: WHEN OTHERS THEN
7569: BEGIN
7570:
7571: SELECT PROJ_ELEMENT_ID, CBS_ELEMENT_ID
7572: INTO l_actual_task_id, l_cbs_element_id
7573: FROM PA_ALTERNATE_TASKS
7574: WHERE alt_task_id = l_task_id_tbl(i);
7575:
7576: EXCEPTION
7577: WHEN OTHERS THEN
9837: BEGIN
9838:
9839: SELECT PROJ_ELEMENT_ID, CBS_ELEMENT_ID
9840: INTO l_actual_task_id, l_cbs_element_id
9841: FROM PA_ALTERNATE_TASKS
9842: WHERE alt_task_id = l_task_id_tbl(i);
9843:
9844: EXCEPTION
9845: WHEN OTHERS THEN
11613: BEGIN
11614:
11615: SELECT PROJ_ELEMENT_ID, CBS_ELEMENT_ID
11616: INTO l_actual_task_id, l_cbs_element_id
11617: FROM PA_ALTERNATE_TASKS
11618: WHERE alt_task_id = l_task_id_tbl(i);
11619:
11620: EXCEPTION
11621: WHEN OTHERS THEN