248: msi.sr_inventory_item_id,
249: nvl(mr.implement_project_id,mr.project_id)
250: FROM msc_calendar_dates cal1,
251: msc_calendar_dates cal2,
252: msc_planners mpl,
253: msc_trading_partners mparam,
254: msc_system_items msi,
255: msc_system_items rsi,
256: msc_supplies mr,
984: var_entity := 'Employee';
985:
986: SELECT count(*)
987: INTO var_count
988: FROM msc_planners
989: WHERE employee_id = var_planner_employee_id
990: AND current_employee_flag= 1;
991:
992: IF var_debug THEN