DBA Data[Home] [Help]

APPS.JTF_CALENDAR_PUB dependencies on JTF_TASK_STATUSES_B

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

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
425: and Decode(p_tz_enabled,'Y',
426: Decode(t.timezone_id,NULL, t.scheduled_end_date,

Line 2114: jtf_task_statuses_b s

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
2117: and p_req_date between
2118: trunc(Decode(p_tz_enabled,'Y',