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 379: jtf_task_assignments a,

375: t.scheduled_end_date)
376: ),
377: t.scheduled_end_date) end_except
378: from jtf_tasks_b t,
379: jtf_task_assignments a,
380: jtf_task_statuses_b s --changed to table from jtf_task_statuses_vl bug #2473783
381: where a.resource_id = p_res_id
382: and a.resource_type_code = p_res_type
383: and Decode(p_tz_enabled,'Y',

Line 2063: jtf_task_assignments a,

2059: ),
2060: t.scheduled_end_date), 'HH24.MI'
2061: ) task_end_time
2062: from jtf_tasks_b t,
2063: jtf_task_assignments a,
2064: jtf_task_statuses_b s
2065: where a.resource_id = p_res_id
2066: and a.resource_type_code = p_res_type
2067: and p_req_date between