1299: task_name
1300: from AHL_SEARCH_VISIT_TASK_V
1301: Where TASK_ID=C_VISIT_TASK_ID;
1302: */
1303: -- AnRaj: Changed the query to remove the use of AHL_MR_HEADERS_VL
1304: -- Bug Number : 5208387
1305: Cursor c_task_info(c_visit_task_id in number)
1306: Is
1307: select mrb.title mr_name,
1327: mrh.description mr_description,
1328: visit_task_number task_number,
1329: visit_task_name task_name
1330: from ahl_visit_tasks_vl tsk,
1331: ahl_mr_headers_vl mrh,
1332: AHL_VISITS_VL AVTS
1333: where MRH.MR_HEADER_ID = TSK.MR_ID
1334: AND NVL(TSK.STATUS_CODE,'X') <> 'DELETED'
1335: AND AVTS.VISIT_ID = TSK.VISIT_ID