APPS.CSFW_TASKS_PUB dependencies on JTF_TASKS_B

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

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

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

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

Line 220: from jtf_tasks_b

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

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

1577:
1578:
1579: CURSOR c_prez_data(v_task_id number)
1580: IS
1581: select object_version_number from jtf_tasks_b where task_id = v_task_id;
1582:
1583:
1584: BEGIN
1585:

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

1666: l_validation_level number;
1667: l_msg_count number;
1668: l_overlap_msg_index number;
1669: CURSOR c_prez_data(v_task_id number) IS
1670: select object_version_number from jtf_tasks_b where task_id = v_task_id;
1671:
1672: BEGIN
1673:
1674: -- Fetch Object Version