[Home] [Help]
402: where bst.calendar_code = l_calendar_code
403: and bst.shift_num = l_shift_num
404: group by bst.shift_num
405: ) st,
406: bom_calendar_shifts bcs
407: where bsd.calendar_code = l_calendar_code
408: and bsd.exception_set_id = -1
409: and bsd.seq_num = l_shift_seq_num
410: and bsd.shift_num = st.shift_num