APPS.JTF_CALENDAR_PUB dependencies on DUAL

Line 2188: from dual;

2184: where calendar_id = l_calendar_id;
2185:
2186: select mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration)
2187: into l_left_days
2188: from dual;
2189:
2190: l_shift_id := null;
2191: for c in shift_info(l_calendar_id) loop
2192: l_left_days := l_left_days - c.shift_duration;

Line 2203: from dual;

2199: -- Find the day of the Requested Date
2200: --
2201: select to_char(l_shift_date, 'd')
2202: into l_unit_of_time_value
2203: from dual;
2204: --
2205: -- Find the working hours on the Requested day
2206: --
2207: --FOR c1 in work_hrs(l_shift_id, l_unit_of_time_value) LOOP