APPS.CSF_TASKS_PUB dependencies on JTF_TASK_STATUSES_VL

Line 165: FROM jtf_task_statuses_vl

161: l_return_value VARCHAR2 (30);
162:
163: CURSOR c_name IS
164: SELECT NAME
165: FROM jtf_task_statuses_vl
166: WHERE task_status_id = p_task_status_id;
167: BEGIN
168: OPEN c_name;
169: FETCH c_name INTO l_return_value;

Line 741: , jtf_task_statuses_vl ts

737: , tt.schedule_flag tt_schedule_flag
738: , ta.resource_name
739: FROM jtf_tasks_b t
740: , csf_ct_task_assignments ta
741: , jtf_task_statuses_vl ts
742: , jtf_task_types_b tt
743: WHERE t.ROWID = CHARTOROWID (p_row_id)
744: AND ts.task_status_id = t.task_status_id
745: AND tt.task_type_id = t.task_type_id

Line 3815: FROM jtf_task_statuses_vl ts, jtf_tasks_b jtb

3811:
3812: CURSOR c_parent_child_tasks (p_task_id NUMBER) IS
3813: SELECT jtb.task_id
3814: , jtb.object_version_number
3815: FROM jtf_task_statuses_vl ts, jtf_tasks_b jtb
3816: WHERE jtb.parent_task_id = p_task_id
3817: AND ts.task_status_id = jtb.task_status_id
3818: AND jtb.task_split_flag = 'D'
3819: AND ( NVL(ts.on_hold_flag, 'N') = 'Y'