APPS.CSF_TASK_DEPENDENCY_PUB dependencies on JTF_TASK_DEPENDS

Line 9: -- NOTE : This package do the operations on jtf_task_depends table

5:
6: -- Package name : CSF_TASK_DEPENDENCY_PUB
7: -- Purpose : This package is related to the task dependency.
8: -- History : Created by sseshaiy on 26-aug-2004
9: -- NOTE : This package do the operations on jtf_task_depends table
10:
11: -- End of Comments
12:
13: g_pkg_name CONSTANT VARCHAR2(30) := 'CSF_TASK_DEPENDENCY_PUB';

Line 402: FROM jtf_task_depends

398: CURSOR c_all_depends (p_task_id NUMBER)
399: IS
400: SELECT dependency_id
401: , object_version_number
402: FROM jtf_task_depends
403: WHERE task_id = p_task_id
404: UNION
405: SELECT dependency_id
406: , object_version_number

Line 407: FROM jtf_task_depends

403: WHERE task_id = p_task_id
404: UNION
405: SELECT dependency_id
406: , object_version_number
407: FROM jtf_task_depends
408: WHERE dependent_on_task_id = p_task_id;
409:
410: l_dependency_id NUMBER;
411: l_object_version_number NUMBER;