DBA Data[Home] [Help]

APPS.JTF_TASK_WF_UTIL dependencies on JTF_TASK_PRIORITIES_TL

Line 537: , jtf_task_priorities_tl tp

533: FROM jtf_tasks_b t
534: , jtf_tasks_tl tl
535: , jtf_task_statuses_tl ts
536: , jtf_task_types_tl tt
537: , jtf_task_priorities_tl tp
538: WHERE t.task_id = p_task_id
539: AND tl.language = userenv('LANG')
540: AND tl.task_id = t.task_id
541: AND ts.task_status_id(+) = t.task_status_id

Line 575: l_old_priority_name jtf_task_priorities_tl.name%TYPE;

571:
572: l_task_rec c_task_details%ROWTYPE;
573:
574: l_old_type_name jtf_task_types_tl.name%TYPE;
575: l_old_priority_name jtf_task_priorities_tl.name%TYPE;
576: l_old_status_name jtf_task_statuses_tl.name%TYPE;
577: l_old_desc jtf_tasks_tl.description%TYPE;
578:
579: l_type_change_text VARCHAR2(70);