APPS.MRP_KANBAN_PLAN_PK dependencies on BOM_CAL_WEEK_START_DATES

Line 318: bom_cal_week_start_dates ws,

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

Line 362: FROM bom_cal_week_start_dates bw,

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

Line 483: FROM bom_cal_week_start_dates bw, mtl_parameters mp

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

Line 3453: FROM bom_cal_week_start_dates bw,

3449: ELSIF p_bucket_type = 2 THEN
3450:
3451: SELECT /*+ first_rows */ bw.week_start_date --bug 5237549
3452: INTO l_offset_date
3453: FROM bom_cal_week_start_dates bw,
3454: mtl_parameters mp
3455: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3456: AND bw.calendar_code = mp.calendar_code
3457: AND bw.exception_set_id = mp.calendar_exception_set_id