APPS.AMS_TASK_PVT dependencies on JTF_TASKS_B

Line 382: FROM jtf_tasks_b

378:
379: CURSOR c_task_type_id(l_task_id IN NUMBER) IS
380: SELECT source_object_type_code,
381: source_object_id
382: FROM jtf_tasks_b
383: WHERE task_id = l_task_id;
384:
385: CURSOR c_task_attr ( p_obj_id in NUMBER, p_obj_type IN VARCHAR2) IS
386: SELECT 'x'

Line 387: FROM jtf_tasks_b

383: WHERE task_id = l_task_id;
384:
385: CURSOR c_task_attr ( p_obj_id in NUMBER, p_obj_type IN VARCHAR2) IS
386: SELECT 'x'
387: FROM jtf_tasks_b
388: WHERE source_object_type_code = p_obj_type
389: AND source_object_id = p_obj_id
390: AND deleted_flag <> 'Y' ;
391:

Line 494: FROM jtf_tasks_b

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
494: FROM jtf_tasks_b
495: WHERE task_id = l_task_id;
496: l_object_version_number number;
497: l_source_object_type_code varchar2(80);
498: l_return_status varchar2(1);