63: ,res.tve_id
64: from jtf_tasks_vl jtb,
65: jtf_task_types_vl jttl,
66: jtf_task_statuses_vl jtsl,
67: okc_resolved_timevalues res
68: where jtb.actual_end_date IS NULL
69: and res.id = jtb.source_object_id
70: and jtb.workflow_process_id IS NULL
71: and jtb.source_object_type_code = 'OKC_RESTIME'
489: ,res.tve_id
490: from jtf_tasks_vl jtb,
491: jtf_task_types_tl jttl,
492: jtf_task_statuses_tl jtsl,
493: okc_resolved_timevalues res
494: where jtb.actual_end_date IS NULL
495: and res.id = jtb.source_object_id
496: and jtb.workflow_process_id IS NOT NULL
497: and jtb.alarm_fired_count IS NULL
932: ,res.tve_id
933: from jtf_tasks_vl jtb,
934: jtf_task_types_vl jttl,
935: jtf_task_statuses_vl jtsl,
936: okc_resolved_timevalues res
937: where jtb.actual_end_date IS NULL
938: and res.id = jtb.source_object_id
939: and jtb.workflow_process_id IS NOT NULL
940: and jtb.alarm_fired_count = 1