eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_CALENDAR_PUB dependencies on JTF_TASK_ASSIGNMENTS

Line 14: -- History : 11/02/01 Chan-ik Jang Changed jtf_task_assignments

10: -- during a specified period
11: -- Procedures : (See below for specification)
12: -- Notes : This package is publicly available for use
13: -- History : 09/29/99 VMOVVA created
14: -- History : 11/02/01 Chan-ik Jang Changed jtf_task_assignments
15: -- to jtf_task_all_assignments
16: -- History : 01/08/02 JAWANG Undo Chan-ik's Changes
17: -- 03/05/02 JAWANG returned attribute1 - 15
18: -- in Get_Resource_Shifts API.

Line 421: jtf_task_assignments a,

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
425: and Decode(p_tz_enabled,'Y',

Line 2113: jtf_task_assignments a,

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
2117: and p_req_date between