SELECT DISTINCT B.TRC , C.DESCR , C.DESCRSHORT FROM PS_TL_WRKGRP_TBL A , PS_TL_TRCPGELE_TBL B ,PS_TL_TRC_TBL C WHERE A.TRC_PROGRAM = B.TRC_PROGRAM AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_TL_WRKGRP_TBL A2 WHERE A2.WORKGROUP = A.WORKGROUP AND A2.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_TL_TRCPGELE_TBL B2 WHERE B2.TRC_PROGRAM = B.TRC_PROGRAM AND B2.EFFDT <= %CurrentDateIn) AND B.TRC = C.TRC AND C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM PS_TL_TRC_TBL C2 WHERE C2.TRC = B.TRC AND C2.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND C.GP_ABSENCE_FLG <> 'Y' AND C.TRC_FILTER = 'N'
|