APPS.JTF_AGENDA_CALCULATIONS dependencies on JTF_AGENDA_TA_V

Line 35: from jtf_agenda_ta_v

31: )
32: is
33: select task_assignment_id
34: , scheduled_end_date
35: from jtf_agenda_ta_v
36: where resource_id = p_res_id
37: and resource_type_code = p_res_type
38: and shift_start = p_shift_start
39: and shift_end = p_shift_end

Line 59: from jtf_agenda_ta_v

55: )
56: is
57: select task_assignment_id
58: , scheduled_end_date
59: from jtf_agenda_ta_v
60: where resource_id = p_res_id
61: and resource_type_code = p_res_type
62: and shift_start = p_shift_start
63: and shift_end = p_shift_end

Line 157: from jtf_agenda_ta_v

153: , bound_mode_code
154: , planned_start_date
155: , planned_end_date
156: , task_type_id
157: from jtf_agenda_ta_v
158: where task_assignment_id = p_ta_id;
159:
160: begin
161: open c_this ( p_task_assignment_id );

Line 282: from jtf_agenda_ta_v

278: , resource_id
279: , resource_type_code
280: , shift_start
281: , shift_end
282: from jtf_agenda_ta_v
283: where task_assignment_id = p_ta_id
284: and actual_start_date is null
285: and actual_end_date is null;
286:

Line 297: from jtf_agenda_ta_v

293: , p_ta_id number
294: )
295: is
296: select 'Y'
297: from jtf_agenda_ta_v
298: where resource_id = p_res_id
299: and resource_type_code = p_res_type
300: and shift_start = p_shift_start
301: and shift_end = p_shift_end

Line 443: from jtf_agenda_ta_v

439: is
440: cursor c_currsta
441: is
442: select assignment_status_id
443: from jtf_agenda_ta_v
444: where resource_id = p_resource_id
445: and resource_type_code = p_resource_type_code
446: and task_type_id not in (20,21)
447: and ( actual_start_date =

Line 449: from jtf_agenda_ta_v

445: and resource_type_code = p_resource_type_code
446: and task_type_id not in (20,21)
447: and ( actual_start_date =
448: ( select max( actual_start_date )
449: from jtf_agenda_ta_v
450: where resource_id = p_resource_id
451: and resource_type_code = p_resource_type_code
452: and task_type_id not in (20,21) )
453: or actual_start_date is null )

Line 504: from jtf_agenda_ta_v

500: is
501: cursor c_currtask
502: is
503: select task_id
504: from jtf_agenda_ta_v
505: where resource_id = p_resource_id
506: and resource_type_code = p_resource_type_code
507: and task_type_id not in (20,21)
508: and ( actual_start_date =

Line 510: from jtf_agenda_ta_v

506: and resource_type_code = p_resource_type_code
507: and task_type_id not in (20,21)
508: and ( actual_start_date =
509: ( select max( actual_start_date )
510: from jtf_agenda_ta_v
511: where resource_id = p_resource_id
512: and resource_type_code = p_resource_type_code
513: and task_type_id not in (20,21) )
514: or actual_start_date is null )