APPS.MRP_KANBAN_PLAN_PK dependencies on BOM_PERIOD_START_DATES

Line 335: bom_period_start_dates ps,

331:
332: SELECT count(*)
333: INTO l_total_workdays
334: FROM bom_calendar_dates cd,
335: bom_period_start_dates ps,
336: mtl_parameters mp
337: WHERE mp.organization_id = g_kanban_info_rec.organization_id
338: AND ps.calendar_code = mp.calendar_code
339: AND ps.exception_set_id = mp.calendar_exception_set_id

Line 374: FROM bom_period_start_dates bp,

370: ELSIF p_bucket_type = 3 THEN
371:
372: SELECT bp.next_date
373: INTO l_next_date
374: FROM bom_period_start_dates bp,
375: mtl_parameters mp
376: WHERE mp.organization_id = g_kanban_info_rec.organization_id
377: AND bp.calendar_code = mp.calendar_code
378: AND bp.exception_set_id = mp.calendar_exception_set_id

Line 473: FROM bom_period_start_dates bp, mtl_parameters mp

469:
470: -- cursor for repetitive periodic forecast dates
471: cursor cur_periodic_forecasts is
472: SELECT bp.period_start_date, bp.next_date
473: FROM bom_period_start_dates bp, mtl_parameters mp
474: WHERE mp.organization_id = g_kanban_info_rec.organization_id
475: AND bp.calendar_code = mp.calendar_code
476: AND bp.exception_set_id = mp.calendar_exception_set_id
477: AND (bp.period_start_date BETWEEN p_demand_date AND

Line 3465: FROM bom_period_start_dates bp,

3461: ELSIF p_bucket_type = 3 THEN
3462:
3463: SELECT bp.period_start_date
3464: INTO l_offset_date
3465: FROM bom_period_start_dates bp,
3466: mtl_parameters mp
3467: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3468: AND bp.calendar_code = mp.calendar_code
3469: AND bp.exception_set_id = mp.calendar_exception_set_id