APPS.CSF_TASKS_PUB dependencies on JTF_TASK_STATUSES_VL

Line 215: FROM jtf_task_statuses_vl

211: l_return_value VARCHAR2 (30);
212:
213: CURSOR c_name IS
214: SELECT NAME
215: FROM jtf_task_statuses_vl
216: WHERE task_status_id = p_task_status_id;
217: BEGIN
218: OPEN c_name;
219: FETCH c_name INTO l_return_value;

Line 828: , jtf_task_statuses_vl ts

824: , tt.schedule_flag tt_schedule_flag
825: , ta.resource_name
826: FROM jtf_tasks_b t
827: , csf_ct_task_assignments ta
828: , jtf_task_statuses_vl ts
829: , jtf_task_types_b tt
830: WHERE t.ROWID = CHARTOROWID (p_row_id)
831: AND ts.task_status_id = t.task_status_id
832: AND tt.task_type_id = t.task_type_id

Line 4463: FROM jtf_task_statuses_vl ts, jtf_tasks_b jtb

4459:
4460: CURSOR c_parent_child_tasks (p_task_id NUMBER) IS
4461: SELECT jtb.task_id
4462: , jtb.object_version_number
4463: FROM jtf_task_statuses_vl ts, jtf_tasks_b jtb
4464: WHERE jtb.parent_task_id = p_task_id
4465: AND ts.task_status_id = jtb.task_status_id
4466: AND jtb.task_split_flag = 'D'
4467: AND ( NVL(ts.on_hold_flag, 'N') = 'Y'