APPS.AMS_TASK_PVT dependencies on JTF_TASK_STATUSES_VL

Line 259: FROM jtf_task_statuses_vl

255: AND item_key like l_task_id || '%'
256: AND activity_status = 'ACTIVE';
257: CURSOR c_check_status is
258: SELECT task_status_id
259: FROM jtf_task_statuses_vl
260: -- WHERE name = 'Assigned';
261: WHERE task_status_id = 14 ;-- 'Assigned';
262: l_status_id number;
263: l_return_flag varchar2(1);

Line 489: FROM jtf_task_statuses_vl

485: AND activity_status = 'ACTIVE';
486:
487: CURSOR c_check_status is
488: SELECT task_status_id
489: FROM jtf_task_statuses_vl
490: -- WHERE name = 'Assigned';
491: WHERE task_status_id = 14 ;-- 'Assigned';
492: CURSOR c_get_status is
493: SELECT task_status_id ,source_object_type_code,object_version_number