90 ) AS ULTIMA, FUN.SALBASE, CASE WHEN FUN.SEXO = 'F' THEN 'Feminino' WHEN FUN.SEXO = 'M' THEN 'Masculino' END AS Sexo, FUN.DTADM FROM TFPFUN FUN INNER JOIN TSIEMP EMP ON FUN.CODEMP = EMP.CODEMP LEFT JOIN TFPDEP DEP ON FUN.CODDEP = DEP.CODDEP LEFT JOIN TFPCAR CAR ON FUN.CODCARGO = CAR.CODCARGO INNER JOIN TFPCBO CBO ON CAR.CODCBO = CBO.CODCBO WHERE ($P{P_CODEMP} IS NULL OR FUN.CODEMP = $P{P_CODEMP}) AND ($P{P_CODCARGO} IS NULL OR FUN.CODCARGO = $P{P_CODCARGO}) AND ($P{P_CODCBO} IS NULL OR CAR.CODCBO = $P{P_CODCBO}) AND FUN.SITUACAO NOT IN (0,8) AND FUN.VINCULO <> 90 ORDER BY FUN.CODEMP, CAR.CODCBO, FUN.NOMEFUNC]]>