APPS.AS_SALES_METH_WF dependencies on JTF_TASKS_VL

Line 900: FROM jtf_tasks_vl

896: l_meth_note_type VARCHAR2(100);
897: l_notes_flag VARCHAR2(10):=NULL;
898: CURSOR c_tasks IS
899: SELECT duration,duration_uom,object_version_number,task_id,description,planned_start_date
900: FROM jtf_tasks_vl
901: WHERE task_id = l_current_task_id;
902: c_tasks_rec c_tasks%ROWTYPE;
903: BEGIN
904: l_notes_flag:='NO';

Line 1161: l_sql:='SELECT task_name FROM jtf_tasks_vl WHERE task_id IN'||'('||l_long_task_id||')';

1157: l_long_task_id := l_long_task_id ||l_column||g_task_tab(n);
1158: END IF;
1159: END LOOP;
1160: ---------------------------------
1161: l_sql:='SELECT task_name FROM jtf_tasks_vl WHERE task_id IN'||'('||l_long_task_id||')';
1162: OPEN c_task_name_ref FOR l_sql;
1163: LOOP
1164: FETCH c_task_name_ref INTO l_task_name;
1165: IF l_long_task_name IS NULL THEN