Hi Guys,

I have a problem with pulling the effective dated row from the ps_health_benefit table
the criteria is like COVERAGE_ELECT = ‘E’ and Max(HB.EFFDT) <= [date entered by the user on page]

I am not able to pull the correct plan type.I tried this query but its failing...Can any one of you guys let me know wher I am failing here

select plan_type from sysadm.ps_health_benefit hb where hb.emplid = '090801' and coverage_elect = 'E' and effdt =( select max(effdt) from sysadm.ps_health_benefit hb_ed where hb.emplid = hb_ed.emplid
and hb.empl_rcd = hb_ed.empl_rcd and hb.cobra_event_id = hb_ed.cobra_event_id and hb.plan_type = hb_ed.plan_type and hb.benefit_nbr = hb_ed.benefit_nbr and hb_ed.effdt < '03/04/2009');

Thanks
Vamsi