|
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','12A','12AA','12B','12BB','12C', '12CC','12D','12DD','12E','12EE','12F','12G','12H','12J','12K','12L','12M','12N','12P','12Q','12R','12S','12T', '12V', '12W','12Y','12Z','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','14YN', '14YT','14Z', '14ZN', '16','17','18','19') 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)
|
BOX