DBA Data[Home] [Help]

APPS.MSC_HORIZONTAL_PLAN_SC dependencies on BOM_CALENDAR_DATES

Line 239: FROM bom_calendar_dates cal

235: var_lucd_seq number ;
236: Begin
237: select cal.prior_seq_num
238: into var_fucd_seq
239: FROM bom_calendar_dates cal
240: WHERE cal.exception_set_id = var_exception_set_id
241: AND cal.calendar_code = var_calendar_code
242: AND cal.calendar_date = TRUNC(fucd) ;
243:

Line 246: FROM bom_calendar_dates cal

242: AND cal.calendar_date = TRUNC(fucd) ;
243:
244: select cal.prior_seq_num
245: into var_lucd_seq
246: FROM bom_calendar_dates cal
247: WHERE cal.exception_set_id = var_exception_set_id
248: AND cal.calendar_code = var_calendar_code
249: AND cal.calendar_date = TRUNC(var_date) ;
250: