DBA Data[Home] [Help]

APPS.MSC_HORIZONTAL_PLAN_SC dependencies on BOM_CALENDAR_DATES

Line 210: FROM bom_calendar_dates cal

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:

Line 217: FROM bom_calendar_dates cal

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: