APPS.CSFW_TASKS_PUB dependencies on JTF_TASKS_B

Line 48: select object_version_number from jtf_tasks_b where task_id = v_task_id;

44:
45:
46: CURSOR c_version (v_task_id NUMBER)
47: IS
48: select object_version_number from jtf_tasks_b where task_id = v_task_id;
49:
50:
51: BEGIN
52:

Line 59: --select object_version_number into l_object_version_number from jtf_tasks_b where task_id = p_task_id;

55: --select the object version number
56: open c_version(p_task_id);
57: fetch c_version into l_object_version_number;
58: close c_version;
59: --select object_version_number into l_object_version_number from jtf_tasks_b where task_id = p_task_id;
60:
61:
62: l_sort_data.field_name := 'TASK_NUMBER'; -- this is redundant as we are passing the primary key
63: l_sort_table (1) := l_sort_data;

Line 217: from jtf_tasks_b

213: CURSOR c_task_location (v_task_id NUMBER)
214: IS
215: Select address_id,
216: location_id
217: from jtf_tasks_b
218: where task_id = v_task_id ;
219:
220: r_task_location c_task_location%ROWTYPE;
221:

Line 1563: select object_version_number from jtf_tasks_b where task_id = v_task_id;

1559:
1560:
1561: CURSOR c_prez_data(v_task_id number)
1562: IS
1563: select object_version_number from jtf_tasks_b where task_id = v_task_id;
1564:
1565:
1566: BEGIN
1567:

Line 1652: select object_version_number from jtf_tasks_b where task_id = v_task_id;

1648: l_validation_level number;
1649: l_msg_count number;
1650:
1651: CURSOR c_prez_data(v_task_id number) IS
1652: select object_version_number from jtf_tasks_b where task_id = v_task_id;
1653:
1654: BEGIN
1655:
1656: -- Fetch Object Version