APPS.JTF_TASKS_PVT dependencies on JTF_TASK_DEPENDS

Line 4414: FROM jtf_task_depends

4410:
4411: CURSOR c_dependencies IS
4412: SELECT dependency_id
4413: , object_version_number
4414: FROM jtf_task_depends
4415: WHERE task_id = l_task_id OR dependent_on_task_id = l_task_id;
4416:
4417: CURSOR c_references IS
4418: SELECT task_reference_id

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

6052: || 'v.attribute_category '
6053: || 'from jtf_tasks_v v ';
6054:
6055: IF (p_query_type = 'DEPENDENCY') THEN
6056: v_select := v_select || ', jtf_task_depends d ';
6057: add_to_sql(p_task_id, 'b1', 'd.dependent_on_task_id');
6058:
6059: IF (v_where IS NOT NULL) THEN
6060: v_select := v_select || ' where v.task_id = d.task_id and ' || v_where;