Work Schedule Query

select * from per_schedule_assignments where schedule_id = 300000058913254 and resource_type <> 'ASSIGN' and end_date >= sysdate

--select * from zmm_sr_schedules_tl where schedule_id = 300000058913254