APPS.CAC_VIEW_WF_PVT dependencies on JTF_TASKS_VL

Line 547: FROM jtf_tasks_vl

543: IS
544: SELECT task_id, owner_id, task_name, description, timezone_id, task_type_id,
545: task_priority_id, calendar_start_date startDate,
546: (calendar_end_date - calendar_start_date)*24*60 duration
547: FROM jtf_tasks_vl
548: WHERE task_id IN
549: (SELECT task_id
550: FROM jtf_task_all_assignments
551: WHERE task_id IN (SELECT task_id

Line 2894: FROM jtf_tasks_vl tsk_vl,

2890: ****************************************************************************/
2891: (p_task_id NUMBER)
2892: IS
2893: SELECT tsk_vl.task_id, owner_id,owner_type_code
2894: FROM jtf_tasks_vl tsk_vl,
2895: jtf_task_all_assignments tsk_asg
2896: WHERE tsk_vl.task_id = p_task_id
2897: and tsk_vl.task_id = tsk_asg.task_id
2898: AND assignee_role = 'OWNER' ;

Line 3353: FROM jtf_tasks_vl tsk_vl,

3349: ****************************************************************************/
3350: (p_task_id NUMBER)
3351: IS
3352: SELECT tsk_vl.task_id, owner_id,owner_type_code
3353: FROM jtf_tasks_vl tsk_vl,
3354: jtf_task_all_assignments tsk_asg
3355: WHERE tsk_vl.task_id = p_task_id
3356: and tsk_vl.task_id = tsk_asg.task_id
3357: AND assignee_role = 'OWNER' ;