APPS.WIP_WS_LABOR_METRIC_PUB dependencies on BOM_SHIFT_DATES

Line 58: bom_shift_dates bsd,

54: select
55: max(bsd.shift_date + st.to_time/(60*60*24))
56: into l_end_time
57: from
58: bom_shift_dates bsd,
59: (select bst.shift_num,
60: min(bst.from_time) from_time,
61: max(decode(sign(bst.to_time - bst.from_time), -1, 24*60*60, 0) + bst.to_time) to_time
62: from bom_shift_times bst

Line 81: bom_shift_dates bsd,

77: select
78: max(bsd.shift_date + st.to_time/(60*60*24))
79: into l_end_time
80: from
81: bom_shift_dates bsd,
82: (select bst.shift_num,
83: max(decode(sign(bst.to_time - bst.from_time), -1, 24*60*60, 0) + bst.to_time) to_time
84: from bom_shift_times bst
85: where bst.calendar_code = p_calendar_code

Line 136: from bom_shift_dates,

132: begin
133: --Fix for bug 11847040, must consider the time component too so that the date will be properly converted
134: select shift_date + at.from_time /(24*60*60)
135: into l_eff_date
136: from bom_shift_dates,
137: (select min(bst.from_time) from_time
138: from bom_shift_times bst
139: where bst.calendar_code = l_calendar_code
140: and bst.shift_num = p_shift_num

Line 175: from bom_shift_dates

171: l_calendar_code := get_calendar_code(p_org_id);
172: begin
173: select shift_date
174: into l_eff_date
175: from bom_shift_dates
176: where calendar_code = l_calendar_code
177: and exception_set_id = -1
178: and seq_num = p_seq_num
179: and shift_num =p_shift_num;

Line 318: from bom_shift_dates bsd,

314: bsd.shift_num shift_num,
315: bsd.shift_date + st.from_time/(60*60*24) shift_start_time,
316: bsd.shift_date + st.to_time/(60*60*24) shift_end_time,
317: (bsd.shift_date + st.to_time/(60*60))-(bsd.shift_date + st.from_time/(60*60)) shift_duration
318: from bom_shift_dates bsd,
319: (select bst.shift_num,
320: min(bst.from_time) from_time,
321: max(bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0)) to_time
322: from bom_shift_times bst