|
SELECT A.BOX , A.DESCR FROM PS_TAXFORM_BOX A WHERE A.BOX IN ('01','02','03','04','05','06','07','08', '09','10','11A','11B','12','13A','13B','13C','13D','13E', '13F','13G','13H','13J','13K','13L','13M','13N','13P','13Q', '13R','13S','13T','14A','14B','14C','14D', '14E','14F','14G','14H', '14I','14J','14K','14L', '14M','14N','14O','14P', '14Q','14R','14S','14T', '14U','14V','14W','14X', '14Y','14Z','17','18','20','21') AND A.TAXFORM_ID = 'W' AND EFFDT = ( SELECT MAX(EFFDT) FROM PS_TAXFORM_BOX B WHERE A.TAXFORM_ID = B.TAXFORM_ID AND A.BOX = B.BOX AND EFFDT <=%DateIn('2000-01-01'))
|
BOX