APPS.JTF_CALENDAR_PUB_24HR dependencies on DUAL

Line 2689: from dual;

2685: where calendar_id = l_calendar_id;
2686: --
2687: select mod((l_shift_date - l_calendar_start_date),l_shifts_total_duration)
2688: into l_left_days
2689: from dual;
2690: --
2691: l_shift_id := Null;
2692: for c in shift_info(l_calendar_id) loop
2693: l_left_days := l_left_days - c.shift_duration;

Line 2706: from dual;

2702: -- Find the day of the Requested Date
2703: --
2704: select to_char(l_shift_date, 'd')
2705: into l_unit_of_time_value
2706: from dual;
2707:
2708:
2709: -- changed in new api by sudar
2710: l_utv := to_char(l_shift_date, 'DAY');