APPS.CSF_MAP_PVT dependencies on JTF_TASK_ASSIGNMENTS

Line 122: jtf_task_assignments jta,

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
126: AND jta.object_capacity_id = cso.object_capacity_id

Line 155: jtf_task_assignments jta,

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
159: AND jta.object_capacity_id = cso.object_capacity_id

Line 251: jtf_task_assignments jta,

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
255: AND jta.task_assignment_id = p_ta_id;

Line 372: FROM jtf_task_assignments jta

368: p_date DATE
369: )
370: IS
371: SELECT task_id
372: FROM jtf_task_assignments jta
373: WHERE jta.resource_id = p_res_id
374: AND jta.resource_type_code = p_res_type
375: AND TRUNC (p_date) BETWEEN TRUNC (jta.booking_start_date)
376: AND TRUNC (jta.booking_end_date);

Line 389: FROM jtf_task_assignments jta, cac_sr_object_capacity cso

385: )
386: ) predicted_start_date,
387: MAX (end_date_time) shift_end
388: -- NVL (jta.actual_end_date, jtb.scheduled_end_date + predict_time_difference (jta.task_assignment_id)) predicted_end_date
389: FROM jtf_task_assignments jta, cac_sr_object_capacity cso
390: WHERE jta.resource_id = p_res_id
391: AND jta.resource_type_code = p_res_type
392: AND TRUNC (p_date) BETWEEN TRUNC (jta.booking_start_date)
393: AND TRUNC (jta.booking_end_date)