DBA Data[Home] [Help]

APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_TASK_STATUSES_B

Line 289: jtf_task_statuses_b s

285: p_start start_assign,
286: p_end end_assign
287: from jtf_tasks_b t,
288: jtf_task_assignments a,
289: jtf_task_statuses_b s
290: where a.resource_id = p_res_id
291: and a.resource_type_code = p_res_type
292: and Decode(p_tz_enabled,'Y',
293: Decode(t.timezone_id,NULL, t.scheduled_start_date,

Line 2486: jtf_task_statuses_b s

2482: ),
2483: t.scheduled_end_date) task_end_time
2484: from jtf_tasks_b t,
2485: jtf_task_assignments a,
2486: jtf_task_statuses_b s
2487: where a.resource_id = p_res_id
2488: and a.resource_type_code = p_res_type
2489: and p_req_date between
2490: trunc(Decode(p_tz_enabled,'Y',