APPS.HR_LOC_WORK_SCHEDULE dependencies on DUAL

Line 74: SELECT replace(trim(to_char(fnd_number.canonical_to_number(l_time),'00.00')),'.',':') FROM dual;

70: --
71: e_bad_time_format EXCEPTION;
72:
73: CURSOR get_time_format(l_time varchar2) is
74: SELECT replace(trim(to_char(fnd_number.canonical_to_number(l_time),'00.00')),'.',':') FROM dual;
75:
76: --
77: BEGIN
78: hr_utility.set_location('Entering '||g_package||'.calc_sch_based_dur',10);

Line 203: FROM DUAL;

199: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
200: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
201: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
202: INTO p_duration
203: FROM DUAL;
204: --
205: -- Get last day hours
206: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
207: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -

Line 210: FROM DUAL;

206: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
207: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
208: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
209: INTO p_duration
210: FROM DUAL;
211: --
212: -- Get between full day hours
213: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
214: INTO p_duration

Line 215: FROM DUAL;

211: --
212: -- Get between full day hours
213: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
214: INTO p_duration
215: FROM DUAL;
216: ELSE
217: -- Start and End on same day
218: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
219: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');

Line 223: FROM DUAL;

219: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
220: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
221: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
222: INTO p_duration
223: FROM DUAL;
224: END IF;
225: END IF;
226: END IF;
227: END IF;