DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on JTF_TASKS_B

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'