APPS.EAM_DOWNTIME_PUB dependencies on BOM_SHIFT_TIMES

Line 330: --logic to see if p_from_tim, p_to_time overlaps with bom_shift_times

326: l_to_time number;
327: i number;
328:
329: begin
330: --logic to see if p_from_tim, p_to_time overlaps with bom_shift_times
331: /* i := 0;
332: for a_shift_time in (select from_time, to_time from bom_shift_times
333: where calendar_code=p_calendar_code and shift_num=p_shift_num) loop
334: i := i+1;

Line 332: for a_shift_time in (select from_time, to_time from bom_shift_times

328:
329: begin
330: --logic to see if p_from_tim, p_to_time overlaps with bom_shift_times
331: /* i := 0;
332: for a_shift_time in (select from_time, to_time from bom_shift_times
333: where calendar_code=p_calendar_code and shift_num=p_shift_num) loop
334: i := i+1;
335: if (i = 1) then
336: l_from_time := a_shift_time.from_time;

Line 343: from bom_shift_times

339: end loop; */
340: -- a shift could have multiple stretches of time
341:
342: select min(from_time), max(to_time) into l_from_time, l_to_time
343: from bom_shift_times
344: where calendar_code = p_calendar_code and shift_num = p_shift_num;
345:
346: IF G_DEBUG = 'Y' THEN
347: fnd_file.put_line(fnd_file.log, 'Check if downtime overlaps shifts:p_from_date'||p_from_date||'p_from_time'||p_from_time||

Line 597: from bom_shift_dates bd,bom_shift_times bt

593:
594: -- Bug # 3787120 Modified cursor query
595: cursor c_wdays is
596: select bd.shift_date,bt.from_time,bt.to_time
597: from bom_shift_dates bd,bom_shift_times bt
598: where trunc(bd.shift_date) >= trunc(p_from_date)
599: and trunc(bd.shift_date) <= trunc(p_to_date)
600: and bd.calendar_code = p_calendar_code
601: and bd.shift_num = p_shift_num