|
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', '12FF','12G','12GG','12H','12HH','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','14S1','14S2','14S3','14S4','14S5','14S6', '14T','14U','14UA','14UB','14UC','14UD','14UE','14UF','14UG','14UH','14UI','14UJ','14UK','14UL','14UM','14UN','14V','14W','14X','14Y', '14YN','14YT','14Z','14ZN','16','17','18','19') OR A.BOX BETWEEN '14PA' AND '14PZ' OR A.BOX BETWEEN '14QA' AND '14QZ' OR A.BOX BETWEEN '14RA' AND '14RZ' OR A.BOX BETWEEN '14SA' AND '14SZ' OR A.BOX BETWEEN '14TA' AND '14TZ') 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