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 135: from bom_shift_dates

131: l_calendar_code := get_calendar_code(p_org_id);
132: begin
133: select shift_date
134: into l_eff_date
135: from bom_shift_dates
136: where calendar_code = l_calendar_code
137: and exception_set_id = -1
138: and seq_num = p_seq_num
139: and shift_num =p_shift_num;

Line 169: from bom_shift_dates

165: l_calendar_code := get_calendar_code(p_org_id);
166: begin
167: select shift_date
168: into l_eff_date
169: from bom_shift_dates
170: where calendar_code = l_calendar_code
171: and exception_set_id = -1
172: and seq_num = p_seq_num
173: and shift_num =p_shift_num;

Line 312: from bom_shift_dates bsd,

308: bsd.shift_num shift_num,
309: bsd.shift_date + st.from_time/(60*60*24) shift_start_time,
310: bsd.shift_date + st.to_time/(60*60*24) shift_end_time,
311: (bsd.shift_date + st.to_time/(60*60))-(bsd.shift_date + st.from_time/(60*60)) shift_duration
312: from bom_shift_dates bsd,
313: (select bst.shift_num,
314: min(bst.from_time) from_time,
315: max(bst.to_time + decode(sign(bst.to_time - bst.from_time), -1, (24*60*60), 0)) to_time
316: from bom_shift_times bst