6020: , jtf_task_types_b jttb
6021: , jtf_task_statuses_tl jtst
6022: , jtf_task_statuses_b jtsb
6023: , jtf_task_priorities_tl jtpt
6024: , jtf_objects_tl jtot
6025: , jtf_objects_b jtob
6026: , jtf_objects_tl jto2
6027: WHERE jta.task_id = p_task_id
6028: AND jta.task_type_id = jttb.task_type_id
6022: , jtf_task_statuses_b jtsb
6023: , jtf_task_priorities_tl jtpt
6024: , jtf_objects_tl jtot
6025: , jtf_objects_b jtob
6026: , jtf_objects_tl jto2
6027: WHERE jta.task_id = p_task_id
6028: AND jta.task_type_id = jttb.task_type_id
6029: AND jta.task_status_id = jtsb.task_status_id
6030: AND (jta.deleted_flag <> 'Y' OR jta.deleted_flag IS NULL)