APPS.JTF_TASKS_PVT dependencies on JTF_TASK_DEPENDS

Line 4495: FROM jtf_task_depends

4491:
4492: CURSOR c_dependencies IS
4493: SELECT dependency_id
4494: , object_version_number
4495: FROM jtf_task_depends
4496: WHERE task_id = l_task_id OR dependent_on_task_id = l_task_id;
4497:
4498: CURSOR c_references IS
4499: SELECT task_reference_id

Line 6137: v_select := v_select || ', jtf_task_depends d ';

6133: || 'v.attribute_category '
6134: || 'from jtf_tasks_v v ';
6135:
6136: IF (p_query_type = 'DEPENDENCY') THEN
6137: v_select := v_select || ', jtf_task_depends d ';
6138: add_to_sql(p_task_id, 'b1', 'd.dependent_on_task_id');
6139:
6140: IF (v_where IS NOT NULL) THEN
6141: v_select := v_select || ' where v.task_id = d.task_id and ' || v_where;