APPS.JTF_TASKS_PUB dependencies on JTF_TASKS_VL

Line 3183: FROM jtf_tasks_vl

3179: p_child_sequence_num
3180: , fnd_api.g_miss_num, child_sequence_num
3181: , p_child_sequence_num
3182: ) child_sequence_num
3183: FROM jtf_tasks_vl
3184: WHERE task_id = l_task_id;
3185:
3186: task_rec c_task_update%ROWTYPE;
3187:

Line 5227: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl

5223: FROM jtf_tasks_b
5224: WHERE task_number = p_task_number;
5225:
5226: CURSOR c_task_name IS
5227: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl
5228: SELECT NULL
5229: FROM jtf_tasks_vl
5230: WHERE task_name = p_task_name AND NVL(deleted_flag, 'N') = 'N';
5231:

Line 5229: FROM jtf_tasks_vl

5225:
5226: CURSOR c_task_name IS
5227: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl
5228: SELECT NULL
5229: FROM jtf_tasks_vl
5230: WHERE task_name = p_task_name AND NVL(deleted_flag, 'N') = 'N';
5231:
5232: v_dummy VARCHAR2(1);
5233: BEGIN

Line 6385: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka

6381: , NVL(tka.show_on_calendar, NULL) show_on_calendar
6382: , NVL(tka.assignment_status_id, NULL) assignment_status_id
6383: , tka.free_busy_type free_busy_type
6384: , tk.entity
6385: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka
6386: WHERE tk.task_id = l_source_task_id AND tk.task_id = tka.task_id(+) AND 'OWNER' = tka.assignee_role(+);
6387:
6388: -- Fetch also assignment details for OWNER, if present, as this is
6389: -- created by the task_create API