DBA Data[Home] [Help]

APPS.JTF_AGENDA_CALCULATIONS dependencies on JTF_AGENDA_V

Line 351: from jtf_agenda_v

347: , p_date date
348: )
349: is
350: select ''
351: from jtf_agenda_v
352: where resource_id = p_res_id
353: and resource_type_code = p_res_type
354: and p_date between shift_start and shift_end
355: and escalation_flag = 'Y';

Line 366: from jtf_agenda_v

362: )
363: is
364: select max(predicted_end_date)
365: , max(shift_end)
366: from jtf_agenda_v
367: where resource_id = p_res_id
368: and resource_type_code = p_res_type
369: and p_date between shift_start and shift_end
370: and task_type_id not in (20,21);