Relatórios RH
02/06/2000 13:04:09
Metas a analisar
<%@ page import="OracleConn" %> <% OracleConn W_CONNECTION = new OracleConn("mts_rel_metas_a_analisar"); W_CONNECTION.f_conectar(); try { java.sql.ResultSet rset = W_CONNECTION.f_select(" select distinct B.id_categoria, B.ds_categoria " + " from tb_mts_categoria B, " + " tb_mts_meta_recurso A " + " where A.id_categoria_fk = B.id_categoria " + " and A.st_aprovada is null " + " and A.st_profissional = 'S' " + " order by B.ds_categoria"); while (rset.next()) { %>
<%= rset.getString(2) %>

<% java.sql.ResultSet rset1 = W_CONNECTION.f_select(" select to_char(A.dt_prevista, 'dd/mm/yyyy'), " + " B.nm_fantasia, " + " A.ds_objetivo_meta " + " from tb_emp_filial B, " + " tb_mts_meta_recurso A " + " where A.id_filial_fk = B.id_filial " + " and A.st_profissional = 'S' " + " and A.st_aprovada is null " + " and A.id_categoria_fk = " + rset.getString(1) + " order by A.dt_prevista, B.nm_fantasia "); while (rset1.next()) { %> <% } rset1.close(); %>
Data Prevista Recurso Descrição
<%= rset1.getString(1) %> <%= rset1.getString(2) %> <%= rset1.getString(3) %>
<% } rset.close(); } catch (Exception e) { out.println(e.toString()); } %> <% W_CONNECTION.f_desconectar(); %>