Line 741: FROM jtf_tasks_b TASK, jtf_task_statuses_b status
737: -- Cursor to check if there are open tasks for the
738: -- repair order.
739: CURSOR task_cur IS
740: SELECT 'x' 741: FROM jtf_tasks_b TASK, jtf_task_statuses_b status 742: WHERE TASK.source_object_id = p_repair_line_id
743: AND TASK.source_object_type_code = 'DR'
744: AND TASK.task_status_id = status.task_status_id
745: AND NVL(status.closed_flag,'N') <> 'Y'