APPS.JTF_CALENDAR_PUB_24HR dependencies on JTF_TASKS_B

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

320: a.end_date_active),p_start) >= p_start -- end after start of range
321: UNION ALL
322: -- For bug 4547539, added db index skip hint to force db to use second indexed
323: -- column schedule_end_date for index search
324: -- Removed /*+ index_ss(T JTF_TASKS_B_N12) */ Hint to address performance issue Bug # 5167257 By MPADHIAR
325:
326: select Decode(p_tz_enabled,'Y',
327: Decode(t.timezone_id,NULL, t.scheduled_start_date,
328: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,

Line 344: from jtf_tasks_b t,

340: ),
341: t.scheduled_end_date) end_except,
342: p_start start_assign,
343: p_end end_assign
344: from jtf_tasks_b t,
345: jtf_task_assignments a,
346: jtf_task_statuses_b s
347: where a.resource_id = p_res_id
348: and a.resource_type_code = p_res_type

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

2515:
2516: 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
2517: -- For bug 4547539, added db index skip hint to force db to use second indexed
2518: -- column schedule_end_date for index search
2519: select /*+ index_ss(T JTF_TASKS_B_N12) */
2520: trunc(Decode(p_tz_enabled,'Y',
2521: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2522: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2523: p_server_tz_id,

Line 2554: from jtf_tasks_b t,

2550: t.scheduled_end_date),
2551: t.scheduled_end_date)
2552: ),
2553: t.scheduled_end_date) task_end_time
2554: from jtf_tasks_b t,
2555: jtf_task_assignments a,
2556: jtf_task_statuses_b s
2557: where a.resource_id = p_res_id
2558: and a.resource_type_code = p_res_type