APPS.JTF_CALENDAR_PUB dependencies on JTF_TASKS_B

Line 420: from jtf_tasks_b t,

416: t.scheduled_end_date),
417: t.scheduled_end_date)
418: ),
419: t.scheduled_end_date) end_except
420: from jtf_tasks_b t,
421: jtf_task_assignments a,
422: jtf_task_statuses_b s --changed to table from jtf_task_statuses_vl bug #2473783
423: where a.resource_id = p_res_id
424: and a.resource_type_code = p_res_type

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

2071: -- modified the query accordingly. Done by SBARAT on 23/06/2005 for Bug# 4443443
2072: --
2073: -- For bug 4547539, added db index skip hint to force db to use second indexed
2074: -- column schedule_end_date for index search
2075: select /*+ index_ss(T JTF_TASKS_B_N12) */
2076: trunc(Decode(p_tz_enabled,'Y',
2077: Decode(t.timezone_id,NULL, t.scheduled_start_date,
2078: Nvl(HZ_TIMEZONE_PUB.CONVERT_DATETIME(t.timezone_id,
2079: p_server_tz_id,

Line 2112: from jtf_tasks_b t,

2108: t.scheduled_end_date)
2109: ),
2110: t.scheduled_end_date), 'HH24.MI'
2111: ) task_end_time
2112: from jtf_tasks_b t,
2113: jtf_task_assignments a,
2114: jtf_task_statuses_b s
2115: where a.resource_id = p_res_id
2116: and a.resource_type_code = p_res_type