DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on JTF_TASKS_B

Line 739: FROM jtf_tasks_b TASK, jtf_task_statuses_b status

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