APPS.CSF_MAP_PVT dependencies on JTF_TASKS_B

Line 13: FROM jtf_tasks_b t, jtf_task_references_vl r, jtf_ec_statuses_vl s

9:
10: CURSOR c_esc
11: IS
12: SELECT NULL
13: FROM jtf_tasks_b t, jtf_task_references_vl r, jtf_ec_statuses_vl s
14: WHERE t.task_id = r.task_id
15: AND t.task_type_id = 22
16: AND t.task_status_id = s.task_status_id
17: AND (s.closed_flag = 'N' OR s.closed_flag IS NULL)

Line 28: FROM jtf_tasks_b t, jtf_task_statuses_vl s

24: CURSOR c_tsk
25: IS
26: SELECT t.source_object_type_code,
27: t.source_object_id
28: FROM jtf_tasks_b t, jtf_task_statuses_vl s
29: WHERE t.task_id = p_task_id
30: AND t.task_status_id = s.task_status_id
31: AND (s.closed_flag = 'N' OR s.closed_flag IS NULL)
32: AND (s.completed_flag = 'N' OR s.completed_flag IS NULL)

Line 121: FROM jtf_tasks_b jtb,

117: )
118: IS
119: SELECT task_assignment_id,
120: scheduled_end_date
121: FROM jtf_tasks_b jtb,
122: jtf_task_assignments jta,
123: cac_sr_object_capacity cso
124: WHERE jta.resource_id = p_res_id
125: AND jta.resource_type_code = p_res_type

Line 154: FROM jtf_tasks_b jtb,

150: )
151: IS
152: SELECT jta.task_assignment_id,
153: jtb.scheduled_end_date
154: FROM jtf_tasks_b jtb,
155: jtf_task_assignments jta,
156: cac_sr_object_capacity cso
157: WHERE jta.resource_id = p_res_id
158: AND jta.resource_type_code = p_res_type

Line 250: FROM jtf_tasks_b jtb,

246: jtb.bound_mode_code,
247: jtb.planned_start_date,
248: jtb.planned_end_date,
249: jtb.task_type_id
250: FROM jtf_tasks_b jtb,
251: jtf_task_assignments jta,
252: cac_sr_object_capacity cso
253: WHERE jta.object_capacity_id = cso.object_capacity_id
254: AND jta.task_id = jtb.task_id