APPS.MRP_KANBAN_PLAN_PK dependencies on BOM_PERIOD_START_DATES

Line 332: bom_period_start_dates ps,

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

Line 371: FROM bom_period_start_dates bp,

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

Line 470: FROM bom_period_start_dates bp, mtl_parameters mp

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

Line 3137: FROM bom_period_start_dates bp,

3133: ELSIF p_bucket_type = 3 THEN
3134:
3135: SELECT bp.period_start_date
3136: INTO l_offset_date
3137: FROM bom_period_start_dates bp,
3138: mtl_parameters mp
3139: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3140: AND bp.calendar_code = mp.calendar_code
3141: AND bp.exception_set_id = mp.calendar_exception_set_id