DBA Data[Home] [Help]

APPS.JTF_CALENDAR_PUB dependencies on JTF_TASK_STATUSES_B

Line 380: jtf_task_statuses_b s --changed to table from jtf_task_statuses_vl bug #2473783

376: ),
377: t.scheduled_end_date) end_except
378: from jtf_tasks_b t,
379: jtf_task_assignments a,
380: jtf_task_statuses_b s --changed to table from jtf_task_statuses_vl bug #2473783
381: where a.resource_id = p_res_id
382: and a.resource_type_code = p_res_type
383: and Decode(p_tz_enabled,'Y',
384: Decode(t.timezone_id,NULL, t.scheduled_end_date,

Line 2064: jtf_task_statuses_b s

2060: t.scheduled_end_date), 'HH24.MI'
2061: ) task_end_time
2062: from jtf_tasks_b t,
2063: jtf_task_assignments a,
2064: jtf_task_statuses_b s
2065: where a.resource_id = p_res_id
2066: and a.resource_type_code = p_res_type
2067: and p_req_date between
2068: trunc(Decode(p_tz_enabled,'Y',