APPS.MRP_KANBAN_PLAN_PK dependencies on BOM_CAL_WEEK_START_DATES

Line 315: bom_cal_week_start_dates ws,

311:
312: SELECT count(*)
313: INTO l_total_workdays
314: FROM bom_calendar_dates cd,
315: bom_cal_week_start_dates ws,
316: mtl_parameters mp
317: WHERE mp.organization_id = g_kanban_info_rec.organization_id
318: AND ws.calendar_code = mp.calendar_code
319: AND ws.exception_set_id = mp.calendar_exception_set_id

Line 359: FROM bom_cal_week_start_dates bw,

355: IF p_bucket_type = 2 THEN
356:
357: SELECT bw.next_date
358: INTO l_next_date
359: FROM bom_cal_week_start_dates bw,
360: mtl_parameters mp
361: WHERE mp.organization_id = g_kanban_info_rec.organization_id
362: AND bw.calendar_code = mp.calendar_code
363: AND bw.exception_set_id = mp.calendar_exception_set_id

Line 480: FROM bom_cal_week_start_dates bw, mtl_parameters mp

476:
477: -- cursor for repetitive weekly forecast dates
478: cursor cur_weekly_forecasts is
479: SELECT bw.week_start_date, bw.next_date
480: FROM bom_cal_week_start_dates bw, mtl_parameters mp
481: WHERE mp.organization_id = g_kanban_info_rec.organization_id
482: AND bw.calendar_code = mp.calendar_code
483: AND bw.exception_set_id = mp.calendar_exception_set_id
484: AND (bw.week_start_date BETWEEN p_demand_date AND

Line 3125: FROM bom_cal_week_start_dates bw,

3121: ELSIF p_bucket_type = 2 THEN
3122:
3123: SELECT /*+ first_rows */ bw.week_start_date --bug 5237549
3124: INTO l_offset_date
3125: FROM bom_cal_week_start_dates bw,
3126: mtl_parameters mp
3127: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3128: AND bw.calendar_code = mp.calendar_code
3129: AND bw.exception_set_id = mp.calendar_exception_set_id