APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_TASKS_B

Line 267: -- Removed /*+ index_ss(T JTF_TASKS_B_N12) */ Hint to address performance issue Bug # 5167257 By MPADHIAR

263: and nvl(a.end_date_active,p_start) >= p_start -- end after start of range
264: UNION ALL
265: -- For bug 4547539, added db index skip hint to force db to use second indexed
266: -- column schedule_end_date for index search
267: -- Removed /*+ index_ss(T JTF_TASKS_B_N12) */ Hint to address performance issue Bug # 5167257 By MPADHIAR
268:
269: select Decode(p_tz_enabled,'Y',
270: Decode(t.timezone_id,NULL, t.scheduled_start_date,
271: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

Line 287: from jtf_tasks_b t,

283: ),
284: t.scheduled_end_date) end_except,
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

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

2445:
2446: cursor task_hrs(p_res_id NUMBER,p_res_type VARCHAR2,p_req_date DATE,p_tz_enabled VARCHAR2,p_server_tz_id NUMBER) is
2447: -- For bug 4547539, added db index skip hint to force db to use second indexed
2448: -- column schedule_end_date for index search
2449: select /*+ index_ss(T JTF_TASKS_B_N12) */
2450: trunc(Decode(p_tz_enabled,'Y',
2451: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2452: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2453: p_server_tz_id,

Line 2484: from jtf_tasks_b t,

2480: t.scheduled_end_date),
2481: t.scheduled_end_date)
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