APPS.JTF_TASKS_PUB dependencies on JTF_TASKS_VL

Line 3184: FROM jtf_tasks_vl

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

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

5248: FROM jtf_tasks_b
5249: WHERE task_number = p_task_number;
5250:
5251: CURSOR c_task_name IS
5252: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl
5253: SELECT NULL
5254: FROM jtf_tasks_vl
5255: WHERE task_name = p_task_name AND NVL(deleted_flag, 'N') = 'N';
5256:

Line 5254: FROM jtf_tasks_vl

5250:
5251: CURSOR c_task_name IS
5252: -- Fix for Bug # 2516412 - changed the view jtf_tasks_v to jtf_tasks_vl
5253: SELECT NULL
5254: FROM jtf_tasks_vl
5255: WHERE task_name = p_task_name AND NVL(deleted_flag, 'N') = 'N';
5256:
5257: v_dummy VARCHAR2(1);
5258: BEGIN

Line 6410: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka

6406: , NVL(tka.show_on_calendar, NULL) show_on_calendar
6407: , NVL(tka.assignment_status_id, NULL) assignment_status_id
6408: , tka.free_busy_type free_busy_type
6409: , tk.entity
6410: FROM jtf_tasks_vl tk, jtf_task_all_assignments tka
6411: WHERE tk.task_id = l_source_task_id AND tk.task_id = tka.task_id(+) AND 'OWNER' = tka.assignee_role(+);
6412:
6413: -- Fetch also assignment details for OWNER, if present, as this is
6414: -- created by the task_create API