APPS.JTF_CALENDAR_PUB dependencies on JTF_TASKS_B

Line 378: from jtf_tasks_b t,

374: t.scheduled_end_date),
375: t.scheduled_end_date)
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

Line 2025: select /*+ index_ss(T JTF_TASKS_B_N12) */

2021: -- modified the query accordingly. Done by SBARAT on 23/06/2005 for Bug# 4443443
2022: --
2023: -- For bug 4547539, added db index skip hint to force db to use second indexed
2024: -- column schedule_end_date for index search
2025: select /*+ index_ss(T JTF_TASKS_B_N12) */
2026: trunc(Decode(p_tz_enabled,'Y',
2027: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2028: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2029: p_server_tz_id,

Line 2062: from jtf_tasks_b t,

2058: t.scheduled_end_date)
2059: ),
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