206: var_lucd_seq number ;
207: Begin
208: select cal.prior_seq_num
209: into var_fucd_seq
210: FROM bom_calendar_dates cal
211: WHERE cal.exception_set_id = var_exception_set_id
212: AND cal.calendar_code = var_calendar_code
213: AND cal.calendar_date = TRUNC(fucd) ;
214:
213: AND cal.calendar_date = TRUNC(fucd) ;
214:
215: select cal.prior_seq_num
216: into var_lucd_seq
217: FROM bom_calendar_dates cal
218: WHERE cal.exception_set_id = var_exception_set_id
219: AND cal.calendar_code = var_calendar_code
220: AND cal.calendar_date = TRUNC(var_date) ;
221: