APPS.JTF_CALENDAR_PUB_24HR dependencies on DUAL

Line 2619: from dual;

2615: where calendar_id = l_calendar_id;
2616: --
2617: select mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration)
2618: into l_left_days
2619: from dual;
2620: --
2621: l_shift_id := Null;
2622: for c in shift_info(l_calendar_id) loop
2623: l_left_days := l_left_days - c.shift_duration;

Line 2636: from dual;

2632: -- Find the day of the Requested Date
2633: --
2634: select to_char(l_shift_date, 'd')
2635: into l_unit_of_time_value
2636: from dual;
2637:
2638:
2639: -- changed in new api by sudar
2640: l_utv := to_char(l_shift_date, 'DAY');