DBA Data[Home] [Help]

APPS.JTF_AGENDA_CALCULATIONS dependencies on JTF_TASK_STATUSES_VL

Line 479: from jtf_task_statuses_vl

475: is
476: cursor c_name
477: is
478: select name
479: from jtf_task_statuses_vl
480: where task_status_id = p_status_id;
481: l_name varchar2(30);
482: begin
483: open c_name;

Line 688: jtf_task_statuses_vl s

684: CURSOR c_tsk IS
685: SELECT t.source_object_type_code,
686: t.source_object_id
687: FROM jtf_tasks_b t,
688: jtf_task_statuses_vl s
689: WHERE t.task_id = p_task_id
690: AND t.task_status_id = s.task_status_id
691: AND (s.closed_flag = 'N'
692: OR s.closed_flag is null)