<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="inf_costo_cgn_consol_anual" language="groovy" pageWidth="2140" pageHeight="612" orientation="Landscape" columnWidth="2100" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.1289478601075549"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/nomina/inf_costo_cgn_det"/>
	<property name="ireport.jasperserver.url" value="http://192.168.2.43:8090/jasperserver/services/repository"/>
	<parameter name="whereArea" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCenOp" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereCargo" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="whereNaturaleza" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="wherePlanta" class="java.lang.String">
		<defaultValueExpression><![CDATA[""]]></defaultValueExpression>
	</parameter>
	<parameter name="id_anhos" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="whereComponenteEscala" class="java.lang.String">
		<defaultValueExpression><![CDATA[" "]]></defaultValueExpression>
	</parameter>
	<parameter name="entidad_cliente" class="java.math.BigDecimal">
		<defaultValueExpression><![CDATA[0]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[select
wm_concat(distinct tab0.codigo) as codigo,
tab0.id_comp_es,
tab0.id_planta_p,
tab0.codigo_concepto,
tab0.denominacion_comp,
tab0.grado_comp,
count(distinct tab0.codigo) as cargo_aprobado,
sum(tab0.cargo_provisto) as cargo_provisto,
tab0.codigo_tipo_vinc,
wm_concat(tab0.num_doc) as num_doc,
wm_concat(tab0.nombre_apellido) as nombre_apellido,

sum(tab0.val_concep_basica) as val_concep_basica,
sum(tab0.val_concep_adicional_ab) as val_concep_adicional_ab,
sum(tab0.val_concep_gasto_repre) as val_concep_gasto_repre,
min(tab0.factor_concep_gasto_repre) as factor_concep_gasto_repre,
sum(tab0.val_concep_primtec_sal) as val_concep_primtec_sal,
min(tab0.factor_concep_primtec_sal) as factor_concep_primtec_sal,
sum(tab0.val_concep_primgest) as val_concep_primgest,
min(tab0.factor_concep_primgest) as factor_concep_primgest,
sum(tab0.val_concep_primloc) as val_concep_primloc,
min(tab0.factor_concep_primloc) as factor_concep_primloc,
sum(tab0.val_concep_primcoor) as val_concep_primcoor,
min(tab0.factor_concep_primcoor) as factor_concep_primcoor,
sum(tab0.val_concep_primries) as val_concep_primries,
min(tab0.factor_concep_primries) as factor_concep_primries,
sum(tab0.val_concep_primaextra) as val_concep_primaextra,
min(tab0.factor_concep_primaextra) as factor_concep_primaextra,
sum(tab0.val_concep_primalt) as val_concep_primalt,
min(tab0.factor_concep_primalt) as factor_concep_primalt,
sum(tab0.val_concep_subalim) as val_concep_subalim,
min(tab0.factor_concep_subalim) as factor_concep_subalim,
sum(tab0.val_concep_auxtrans) as val_concep_auxtrans,
min(tab0.factor_concep_auxtrans) as factor_concep_auxtrans,
sum(tab0.val_concep_aux_conect) as val_concep_aux_conect,
min(tab0.factor_concep_aux_conect) as factor_concep_aux_conect,
sum(tab0.val_concep_primant) as val_concep_primant,
min(tab0.factor_concep_primant) as factor_concep_primant,
sum(tab0.val_concep_primserv) as val_concep_primserv,
min(tab0.factor_concep_primserv) as factor_concep_primserv,
sum(tab0.val_concep_primnav) as val_concep_primnav,
min(tab0.factor_concep_primnav) as factor_concep_primnav,
sum(tab0.val_concep_bonif) as val_concep_bonif,
min(tab0.factor_concep_bonif) as factor_concep_bonif,
sum(tab0.val_concep_bonfrec) as val_concep_bonfrec,
min(tab0.factor_concep_bonfrec) as factor_concep_bonfrec,
sum(tab0.val_concep_primvac) as val_concep_primvac,
min(tab0.factor_concep_primvac) as factor_concep_primvac,
sum(tab0.val_concep_indem_vac) as val_concep_indem_vac,
sum(tab0.val_concep_primact) as val_concep_primact,
min(tab0.factor_concep_primact) as factor_concep_primact,
sum(tab0.val_concep_otraprim_sal) as val_concep_otraprim_sal,
sum(tab0.val_concep_otraprim_no_sal) as val_concep_otraprim_no_sal,
sum(tab0.val_concep_cesanu) as val_concep_cesanu,
sum(tab0.val_concep_cesanual) as val_concep_cesanual,
sum(tab0.val_int_cesanu) as val_int_cesanu,

min(tab0.fecha_ingreso) as fecha_ingreso,
max(tab0.fecha_retiro) as fecha_retiro

from(

    select
    tab0.id_dp,
    tab0.codigo,
    tab0.id_comp_es,
    tab0.id_planta_p,
    tab0.codigo_concepto,
    tab0.denominacion_comp,
    tab0.grado_comp,
    tab0.cargo_aprobado,
    tab0.cargo_provisto,
    tab0.codigo_tipo_vinc,
    tab0.num_doc,
    tab0.nombre_apellido,

    tab0.val_concep_basica,
    tab0.val_concep_adicional_ab,
    tab0.val_concep_gasto_repre,
    tab0.factor_concep_gasto_repre,
    tab0.val_concep_primtec_sal,
    tab0.factor_concep_primtec_sal,
    tab0.val_concep_primgest,
    tab0.factor_concep_primgest,
    tab0.val_concep_primloc,
    tab0.factor_concep_primloc,
    tab0.val_concep_primcoor,
    tab0.factor_concep_primcoor,
    tab0.val_concep_primries,
    tab0.factor_concep_primries,
    tab0.val_concep_primaextra,
    tab0.factor_concep_primaextra,
    tab0.val_concep_primalt,
    tab0.factor_concep_primalt,
    tab0.val_concep_subalim,
    tab0.factor_concep_subalim,
    tab0.val_concep_auxtrans,
    tab0.factor_concep_auxtrans,
    tab0.val_concep_aux_conect,
    tab0.factor_concep_aux_conect,
    tab0.val_concep_primant,
    tab0.factor_concep_primant,
    tab0.val_concep_primserv,
    tab0.factor_concep_primserv,
    tab0.val_concep_primnav,
    tab0.factor_concep_primnav,
    tab0.val_concep_bonif,
    tab0.factor_concep_bonif,
    tab0.val_concep_bonfrec,
    tab0.factor_concep_bonfrec,
    tab0.val_concep_primvac,
    tab0.factor_concep_primvac,
    tab0.val_concep_indem_vac,
    tab0.val_concep_primact,
    tab0.factor_concep_primact,
    tab0.val_concep_otraprim_sal,
    tab0.val_concep_otraprim_no_sal,
    tab0.val_concep_cesanu,
    tab0.val_concep_cesanual as val_concep_cesanual,
    tab0.val_concep_intcesant as val_int_cesanu,

    nom.fecha_ingreso,
    nom.fecha_retiro

    from(
        select
        1 as tag_orden,
        tab0.id_dp,
        tab0.codigo,
        tab0.id_comp_es,
        tab0.id_planta_p,
        tab0.codigo_concepto,
        tab0.denominacion_comp,
        tab0.grado_comp,
        1 as cargo_aprobado,
        nvl2(tab0.num_doc,1,0) as cargo_provisto,
        tab0.codigo_tipo_vinc,
        tab0.num_doc,
        tab0.nombre_apellido,

        sum(case when tab0.id_concep_basica = tab0.id_concep_nomina then case when tab0.valor>0 then tab0.valor else tab0.asignacion_basica end else 0 end) as val_concep_basica,
        sum(case when tab0.id_concep_adicional_ab = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_adicional_ab,
        sum(case when tab0.id_concep_gasto_repre = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_gasto_repre,
        max(case when tab0.id_concep_gasto_repre = tab0.id_concep_nomina and tab0.valor>0 then tab0.factor_salarial else 0 end) as factor_concep_gasto_repre,
        sum(case when tab0.id_concep_primtec_sal = tab0.id_concep_nomina or tab0.id_concep_primtec_nosal = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primtec_sal,
        max(case when tab0.id_concep_primtec_sal = tab0.id_concep_nomina and tab0.valor>0  then tab0.factor_salarial
                 when tab0.id_concep_primtec_nosal = tab0.id_concep_nomina and tab0.valor>0 then tab0.factor_salarial else 0 end) as factor_concep_primtec_sal,
        sum(case when tab0.id_concep_primgest = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primgest,
        max(case when tab0.id_concep_primgest = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primgest,
        sum(case when tab0.id_concep_primloc = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primloc,
        max(case when tab0.id_concep_primloc = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primloc,
        sum(case when tab0.id_concep_primcoor = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primcoor,
        max(case when tab0.id_concep_primcoor = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primcoor,
        sum(case when tab0.id_concep_primries = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primries,
        max(case when tab0.id_concep_primries = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primries,
        sum(case when tab0.id_concep_primaextra = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primaextra,
        max(case when tab0.id_concep_primaextra = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primaextra,
        sum(case when tab0.id_concep_primalt = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primalt,
        max(case when tab0.id_concep_primalt = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primalt,
        sum(case when tab0.id_concep_subalim = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_subalim,
        max(case when tab0.id_concep_subalim = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_subalim,
        sum(case when tab0.id_concep_auxtrans = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_auxtrans,
        max(case when tab0.id_concep_auxtrans = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_auxtrans,
        sum(case when tab0.id_concep_aux_conect = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_aux_conect,
        max(case when tab0.id_concep_aux_conect = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_aux_conect,
        sum(case when tab0.id_concep_primant = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primant,
        max(case when tab0.id_concep_primant = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primant,
        sum(case when tab0.id_concep_primserv = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primserv,
        max(case when tab0.id_concep_primserv = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primserv,
        sum(case when tab0.id_concep_primnav = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primnav,
        max(case when tab0.id_concep_primnav = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primnav,
        sum(case when tab0.id_concep_bonif = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_bonif,
        max(case when tab0.id_concep_bonif = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_bonif,
        sum(case when tab0.id_concep_bonfrec = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_bonfrec,
        max(case when tab0.id_concep_bonfrec = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_bonfrec,
        sum(case when tab0.id_concep_primvac = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primvac,
        max(case when tab0.id_concep_primvac = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primvac,
        sum(case when tab0.id_concep_indem_vac = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_indem_vac,
        sum(case when tab0.id_concep_primact = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primact,
        max(case when tab0.id_concep_primact = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primact,

        sum(case when tab0.id_concep_intcesant = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_intcesant,
        sum(case when tab0.id_concep_cesanu = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_cesanu,
        sum(case when tab0.id_concep_cesanual = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_cesanual,


        sum(case when tab0.id_concep_nomina not in (tab0.id_concep_basica,tab0.id_concep_adicional_ab,tab0.id_concep_gasto_repre,tab0.id_concep_primtec_sal,tab0.id_concep_primtec_nosal,tab0.id_concep_primgest,
                                          tab0.id_concep_primloc,tab0.id_concep_primcoor,tab0.id_concep_primries,tab0.id_concep_primaextra,tab0.id_concep_primalt,tab0.id_concep_subalim,tab0.id_concep_auxtrans,tab0.id_concep_aux_conect,
                                          tab0.id_concep_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_indem_vac,tab0.id_concep_primact,tab0.id_concep_bonif
                                         ,tab0.id_concep_cesanu,tab0.id_concep_cesanual) and tab0.factor_salarial=1 then tab0.valor else 0 end) as val_concep_otraprim_sal,
        sum(case when tab0.id_concep_nomina not in (tab0.id_concep_basica,tab0.id_concep_adicional_ab,tab0.id_concep_gasto_repre,tab0.id_concep_primtec_sal,tab0.id_concep_primtec_nosal,tab0.id_concep_primgest,
                                          tab0.id_concep_primloc,tab0.id_concep_primcoor,tab0.id_concep_primries,tab0.id_concep_primaextra,tab0.id_concep_primalt,tab0.id_concep_subalim,tab0.id_concep_auxtrans,tab0.id_concep_aux_conect,
                                          tab0.id_concep_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_indem_vac,tab0.id_concep_primact,tab0.id_concep_bonif
                                         ,tab0.id_concep_cesanu,tab0.id_concep_cesanual) and tab0.factor_salarial=0 then tab0.valor else 0 end) as val_concep_otraprim_no_sal

        from(
            SELECT
            tab0.id_dp,
            tab0.codigo,
            tab0.id_comp_es,
            tab0.id_planta_p,
            tab0.codigo_concepto,
            tab0.denominacion_comp,
            tab0.grado_comp,
            tab0.codigo_tipo_vinc,
            nvl(phas.salario,tab0.asignacion_basica) as asignacion_basica,
            tab1.num_doc as num_doc,
            tab1.nombre_apellido,

            tab2.id_concep_nomina,
            tab2.tipo_valor,
            tab3.factor_salarial,
            case when tab1.num_doc is not null
            then
                case
                when tab2.tipo_valor = 'Z'
                    then trunc(nvl(no_consulta_sql_f($P{id_anhos}- (case when $P{entidad_cliente} in (8) then 1 else 0 end),1,$P{id_anhos}- (case when $P{entidad_cliente} in (8) then 1 else 0 end),12,nvl(tab1.id_tipo_doc,0),nvl(tab1.num_doc,0),tab2.id_concep_nomina,tab2.tipo_valor,0),0))
                when tab2.tipo_valor != 'X'
                     then trunc(nvl(no_consulta_sql_f(tab1.anho_estado_func,1,tab1.anho_estado_func,12,tab1.id_tipo_doc,tab1.num_doc,tab2.id_concep_nomina,tab2.tipo_valor,tab1.id_periodo),0))
                else trunc(nvl(no_consulta_sql_f(tab1.anho_estado_func,1,tab1.anho_estado_func,12,tab1.id_tipo_doc,tab1.num_doc,tab2.id_concep_nomina,tab2.tipo_valor,nvl(antvig.id_periodo,0)),0))  end
            else 0 end as valor,

            nvl(tab4.id_concep_basica,0) as id_concep_basica,
            nvl(tab4.id_concep_adicional_ab,0) as id_concep_adicional_ab,
            nvl(tab4.id_concep_gasto_repre,0) as id_concep_gasto_repre,
            nvl(tab4.id_concep_primtec_sal,0) as id_concep_primtec_sal,
            nvl(tab4.id_concep_primtec_nosal,0) as id_concep_primtec_nosal,
            nvl(tab4.id_concep_primgest,0) as id_concep_primgest,
            nvl(tab4.id_concep_primloc,0) as id_concep_primloc,
            nvl(tab4.id_concep_primcoor,0) as id_concep_primcoor,
            nvl(tab4.id_concep_primries,0) as id_concep_primries,
            nvl(tab4.id_concep_primaextra,0) as id_concep_primaextra,
            nvl(tab4.id_concep_primalt,0) as id_concep_primalt,
            nvl(tab4.id_concep_subalim,0) as id_concep_subalim,
            nvl(tab4.id_concep_auxtrans,0) as id_concep_auxtrans,
            nvl(tab4.id_concep_aux_conect,0) as id_concep_aux_conect,
            nvl(tab4.id_concep_primant,0) as id_concep_primant,
            nvl(tab4.id_concep_primserv,0) as id_concep_primserv,
            nvl(tab4.id_concep_primnav,0) as id_concep_primnav,
            nvl(tab4.id_concep_bonfrec,0) as id_concep_bonfrec,
            nvl(tab4.id_concep_primvac,0) as id_concep_primvac,
            nvl(tab4.id_concep_indem_vac,0) as id_concep_indem_vac,
            nvl(tab4.id_concep_primact,0) as id_concep_primact,
            nvl(tab4.id_concep_bonif,0) as id_concep_bonif,
            nvl(tab4.id_concep_intcesant,0) as id_concep_intcesant,
            nvl(tab4.id_concep_cesanual,0) as id_concep_cesanual,
            nvl(case when tab2.tipo_valor in ( 'X','Z' ) then tab2.id_concep_nomina else 0 end,0) as id_concep_cesanu

            FROM no_dp_v tab0

            left join (
                SELECT
                 aut.*,
                 ROW_NUMBER() OVER (
                  partition by aut.id_com_es
                  ORDER BY aut.id_com_es ASC, aut.fecha DESC
                 ) AS rn
                from rh_pn_as aut
                where
                extract(year from aut.fecha) = $P{id_anhos}
            )phas
            on phas.id_com_es = tab0.id_comp_es
            and phas.rn = 1

            LEFT JOIN(
                SELECT
                tab1.id_dp,
                tab1.id_tipo_doc,
                tab1.num_doc,
                tab3.nombre_apellido,
                tab1.id_anhos as anho_estado_func,
                tab1.id_meses as meses_estado_func,
                tab1.periodo as id_periodo

                FROM no_estado_func_v tab1

                JOIN no_periodo tab2
                ON tab2.id_periodo = tab1.periodo
                AND tab2.id_anhos = tab1.id_anhos

                LEFT JOIN no_datos_funcionario_v tab3 ON tab3.num_doc=tab1.num_doc

                LEFT JOIN no_nombramiento_v nom ON nom.num_doc = tab1.num_doc

                WHERE
                tab1.id_meses = 12
                AND tab2.id_tipo_periodo = 1
                AND tab1.id_anhos = $P{id_anhos}
                AND tab1.actual = 1
                and (nom.fecha_retiro is null or nom.fecha_termina > to_date( $P{id_anhos} || '12-31','yyyy-mm-dd'))

            )tab1
            ON tab0.id_dp = tab1.id_dp

            LEFT JOIN(
                SELECT
                tab1.id_dp,
                tab1.id_tipo_doc,
                tab1.num_doc,
                tab3.nombre_apellido,
                tab1.id_anhos as anho_estado_func,
                tab1.id_meses as meses_estado_func,
                tab1.periodo as id_periodo

                FROM no_estado_func_v tab1

                JOIN no_periodo tab2
                ON tab2.id_periodo = tab1.periodo
                AND tab2.id_anhos = tab1.id_anhos

                LEFT JOIN no_datos_funcionario_v tab3 ON tab3.num_doc=tab1.num_doc

                LEFT JOIN no_nombramiento_v nom ON nom.num_doc = tab1.num_doc

                WHERE
                tab1.id_meses = 12
                AND tab2.id_tipo_periodo = 1
                AND tab1.id_anhos = $P{id_anhos} - (case when $P{entidad_cliente} in (8) then 1 else 0 end)
                AND tab1.actual = 1
                and (nom.fecha_retiro is null or nom.fecha_retiro >= to_date( $P{id_anhos} || '12-31','yyyy-mm-dd'))

            )antvig
            ON tab0.id_dp = antvig.id_dp
            and tab1.num_doc = antvig.num_doc

            left join(

              select
              agrup.id_concep_nomina,
              agrup.id_agrup_concepto,
              agrup.tipo_valor
              from no_agrup_deta agrup

              where
              agrup.id_agrup_concepto = 126

              union

              select
              agrup.id_concep_nomina,
              agrup.id_agrup_concepto,
              'Z' as tipo_valor
              from no_agrup_deta agrup

              where
              agrup.id_agrup_concepto = (select id_agrup_cesanu from no_param_concep where id_param_concep = 1)

            )tab2 on tab2.id_agrup_concepto != 0

            left join no_concep_nomina tab3 on tab3.id_concep_nomina=tab2.id_concep_nomina

            LEFT JOIN no_param_concep tab4 ON tab4.id_param_concep = 1

            left join (

                select distinct
                liq.num_doc,
                liq.id_concep_nomina
                from no_liquida_nomina liq
                left join no_periodo per
                on per.id_periodo = liq.id_periodo
                where
                per.id_anhos = $P{id_anhos}

                union

                select distinct
                liq.num_doc,
                    (select
                    max(agrup.id_concep_nomina)
                    from no_agrup_deta agrup
                    where
                    agrup.id_agrup_concepto = (select id_agrup_cesanu from no_param_concep where id_param_concep = 1) ) as id_concep_nomina
                from no_liquida_nomina liq
                left join no_periodo per
                on per.id_periodo = liq.id_periodo
                where
                per.id_anhos = $P{id_anhos}

            )liq
            on liq.num_doc = tab1.num_doc
            and liq.id_concep_nomina = tab2.id_concep_nomina

            where
            1 = 1
            $P!{wherePlanta}

        )tab0

        group by
        tab0.id_dp,
        tab0.codigo,
        tab0.id_comp_es,
        tab0.id_planta_p,
        tab0.codigo_concepto,
        tab0.denominacion_comp,
        tab0.grado_comp,
        tab0.codigo_tipo_vinc,
        tab0.num_doc,
        tab0.nombre_apellido

        union

        select
        2 as tag_orden,
        tab0.id_dp,
        tab0.codigo,
        tab0.id_comp_es,
        tab0.id_planta_p,
        tab0.codigo_concepto,
        tab0.denominacion_comp,
        tab0.grado_comp,
        1 as cargo_aprobado,
        nvl2(tab0.num_doc,1,0) as cargo_provisto,
        tab0.codigo_tipo_vinc,
        tab0.num_doc,
        tab0.nombre_apellido,

        sum(case when tab0.id_concep_basica = tab0.id_concep_nomina then case when tab0.valor>0 then tab0.valor else tab0.asignacion_basica end else 0 end) as val_concep_basica,
        sum(case when tab0.id_concep_adicional_ab = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_adicional_ab,
        sum(case when tab0.id_concep_gasto_repre = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_gasto_repre,
        max(case when tab0.id_concep_gasto_repre = tab0.id_concep_nomina and tab0.valor>0 then tab0.factor_salarial else 0 end) as factor_concep_gasto_repre,
        sum(case when tab0.id_concep_primtec_sal = tab0.id_concep_nomina or tab0.id_concep_primtec_nosal = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primtec_sal,
        max(case when tab0.id_concep_primtec_sal = tab0.id_concep_nomina and tab0.valor>0  then tab0.factor_salarial
                 when tab0.id_concep_primtec_nosal = tab0.id_concep_nomina and tab0.valor>0 then tab0.factor_salarial else 0 end) as factor_concep_primtec_sal,
        sum(case when tab0.id_concep_primgest = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primgest,
        max(case when tab0.id_concep_primgest = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primgest,
        sum(case when tab0.id_concep_primloc = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primloc,
        max(case when tab0.id_concep_primloc = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primloc,
        sum(case when tab0.id_concep_primcoor = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primcoor,
        max(case when tab0.id_concep_primcoor = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primcoor,
        sum(case when tab0.id_concep_primries = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primries,
        max(case when tab0.id_concep_primries = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primries,
        sum(case when tab0.id_concep_primaextra = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primaextra,
        max(case when tab0.id_concep_primaextra = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primaextra,
        sum(case when tab0.id_concep_primalt = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primalt,
        max(case when tab0.id_concep_primalt = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primalt,
        sum(case when tab0.id_concep_subalim = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_subalim,
        max(case when tab0.id_concep_subalim = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_subalim,
        sum(case when tab0.id_concep_auxtrans = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_auxtrans,
        max(case when tab0.id_concep_auxtrans = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_auxtrans,
        sum(case when tab0.id_concep_aux_conect = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_aux_conect,
        max(case when tab0.id_concep_aux_conect = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_aux_conect,
        sum(case when tab0.id_concep_primant = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primant,
        max(case when tab0.id_concep_primant = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primant,
        sum(case when tab0.id_concep_primserv = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primserv,
        max(case when tab0.id_concep_primserv = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primserv,
        sum(case when tab0.id_concep_primnav = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primnav,
        max(case when tab0.id_concep_primnav = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primnav,
        sum(case when tab0.id_concep_bonif = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_bonif,
        max(case when tab0.id_concep_bonif = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_bonif,
        sum(case when tab0.id_concep_bonfrec = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_bonfrec,
        max(case when tab0.id_concep_bonfrec = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_bonfrec,
        sum(case when tab0.id_concep_primvac = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primvac,
        max(case when tab0.id_concep_primvac = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primvac,
        sum(case when tab0.id_concep_indem_vac = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_indem_vac,
        sum(case when tab0.id_concep_primact = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_primact,
        max(case when tab0.id_concep_primact = tab0.id_concep_nomina then tab0.factor_salarial else 0 end) as factor_concep_primact,

        sum(case when tab0.id_concep_intcesant = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_intcesant,
        sum(case when tab0.id_concep_cesanu = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_cesanu,
        sum(case when tab0.id_concep_cesanual = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_cesanual,

        sum(case when tab0.id_concep_nomina not in (tab0.id_concep_basica,tab0.id_concep_adicional_ab,tab0.id_concep_gasto_repre,tab0.id_concep_primtec_sal,tab0.id_concep_primtec_nosal,tab0.id_concep_primgest,
                                          tab0.id_concep_primloc,tab0.id_concep_primcoor,tab0.id_concep_primries,tab0.id_concep_primaextra,tab0.id_concep_primalt,tab0.id_concep_subalim,tab0.id_concep_auxtrans,tab0.id_concep_aux_conect,
                                          tab0.id_concep_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_indem_vac,tab0.id_concep_primact,tab0.id_concep_bonif
                                         ,tab0.id_concep_cesanu,tab0.id_concep_cesanual) and tab0.factor_salarial=1 then tab0.valor else 0 end) as val_concep_otraprim_sal,
        sum(case when tab0.id_concep_nomina not in (tab0.id_concep_basica,tab0.id_concep_adicional_ab,tab0.id_concep_gasto_repre,tab0.id_concep_primtec_sal,tab0.id_concep_primtec_nosal,tab0.id_concep_primgest,
                                          tab0.id_concep_primloc,tab0.id_concep_primcoor,tab0.id_concep_primries,tab0.id_concep_primaextra,tab0.id_concep_primalt,tab0.id_concep_subalim,tab0.id_concep_auxtrans,tab0.id_concep_aux_conect,
                                          tab0.id_concep_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_indem_vac,tab0.id_concep_primact,tab0.id_concep_bonif
                                         ,tab0.id_concep_cesanu,tab0.id_concep_cesanual) and tab0.factor_salarial=0 then tab0.valor else 0 end) as val_concep_otraprim_no_sal

        from(
            SELECT
            tab0.id_dp,
            tab0.codigo,
            tab0.id_comp_es,
            tab0.id_planta_p,
            tab0.codigo_concepto,
            tab0.denominacion_comp,
            tab0.grado_comp,
            tab0.codigo_tipo_vinc,
            nvl(phas.salario,tab0.asignacion_basica) as asignacion_basica,
            tab1.num_doc as num_doc,
            tab1.nombre_apellido,

            tab2.id_concep_nomina,
            tab2.tipo_valor,
            tab3.factor_salarial,
            case
            when tab2.tipo_valor = 'Z'
                    then trunc(nvl(no_consulta_sql_f($P{id_anhos}- (case when $P{entidad_cliente} in (8) then 1 else 0 end),1,$P{id_anhos}- (case when $P{entidad_cliente} in (8) then 1 else 0 end),12,nvl(tab1.id_tipo_doc,0),nvl(tab1.num_doc,0),tab2.id_concep_nomina,tab2.tipo_valor,0),0))
            when tab1.num_doc is not null then trunc(nvl(no_consulta_sql_f(tab1.anho_estado_func,1,tab1.anho_estado_func,12,tab1.id_tipo_doc,tab1.num_doc,tab2.id_concep_nomina,tab2.tipo_valor,tab1.id_periodo),0)) else 0 end as valor,

            nvl(tab4.id_concep_basica,0) as id_concep_basica,
            nvl(tab4.id_concep_adicional_ab,0) as id_concep_adicional_ab,
            nvl(tab4.id_concep_gasto_repre,0) as id_concep_gasto_repre,
            nvl(tab4.id_concep_primtec_sal,0) as id_concep_primtec_sal,
            nvl(tab4.id_concep_primtec_nosal,0) as id_concep_primtec_nosal,
            nvl(tab4.id_concep_primgest,0) as id_concep_primgest,
            nvl(tab4.id_concep_primloc,0) as id_concep_primloc,
            nvl(tab4.id_concep_primcoor,0) as id_concep_primcoor,
            nvl(tab4.id_concep_primries,0) as id_concep_primries,
            nvl(tab4.id_concep_primaextra,0) as id_concep_primaextra,
            nvl(tab4.id_concep_primalt,0) as id_concep_primalt,
            nvl(tab4.id_concep_subalim,0) as id_concep_subalim,
            nvl(tab4.id_concep_auxtrans,0) as id_concep_auxtrans,
            nvl(tab4.id_concep_aux_conect,0) as id_concep_aux_conect,
            nvl(tab4.id_concep_primant,0) as id_concep_primant,
            nvl(tab4.id_concep_primserv,0) as id_concep_primserv,
            nvl(tab4.id_concep_primnav,0) as id_concep_primnav,
            nvl(tab4.id_concep_bonfrec,0) as id_concep_bonfrec,
            nvl(tab4.id_concep_primvac,0) as id_concep_primvac,
            nvl(tab4.id_concep_indem_vac,0) as id_concep_indem_vac,
            nvl(tab4.id_concep_primact,0) as id_concep_primact,
            nvl(tab4.id_concep_bonif,0) as id_concep_bonif,
            nvl(tab4.id_concep_intcesant,0) as id_concep_intcesant,
            nvl(tab4.id_concep_cesanual,0) as id_concep_cesanual,
            nvl(case when tab2.tipo_valor in ( 'Y','Z' ) then tab2.id_concep_nomina else 0 end,0) as id_concep_cesanu

            FROM no_dp_v tab0

            left join (
                SELECT
                 aut.*,
                 ROW_NUMBER() OVER (
                  partition by aut.id_com_es
                  ORDER BY aut.id_com_es ASC, aut.fecha DESC
                 ) AS rn
                from rh_pn_as aut
                where
                extract(year from aut.fecha) = $P{id_anhos}
            )phas
            on phas.id_com_es = tab0.id_comp_es
            and phas.rn = 1

            LEFT JOIN(
                SELECT
                tab1.id_dp,
                tab1.id_tipo_doc,
                tab1.num_doc,
                tab3.nombre_apellido,
                tab1.id_anhos as anho_estado_func,
                tab1.id_meses as meses_estado_func,
                tab1.periodo as id_periodo

                FROM no_nombramiento_v nom

                --LEFT JOIN no_estado_func_v tab1 ON nom.num_doc = tab1.num_doc
                left join (
                      SELECT
                       aut.*,
                       ROW_NUMBER() OVER (
                        partition by aut.num_doc
                        ORDER BY aut.id_anhos desc, aut.id_meses desc, aut.actual desc
                       ) AS rnn
                      from no_estado_func_v aut

                        JOIN no_periodo tab2
                        ON tab2.id_periodo = aut.periodo
                        AND tab2.id_anhos = aut.id_anhos

                      where
                      aut.id_anhos = $P{id_anhos}
                      and tab2.id_tipo_periodo = 1
                )tab1
                ON nom.num_doc = tab1.num_doc
                and tab1.rnn = 1

                JOIN no_periodo tab2
                ON tab2.id_periodo = tab1.periodo
                AND tab2.id_anhos = tab1.id_anhos

                LEFT JOIN no_datos_funcionario_v tab3 ON tab3.num_doc=tab1.num_doc

                WHERE
                /*tab1.id_meses = 12
                AND*/ tab2.id_tipo_periodo = 1
                AND tab1.id_anhos = $P{id_anhos}
                --AND tab1.actual = 1
                and nom.fecha_retiro is not null
                and (nom.fecha_termina BETWEEN to_date( $P{id_anhos} || '-01-01','yyyy-mm-dd') and to_date( $P{id_anhos} || '-12-31','yyyy-mm-dd'))

                union

                SELECT
                tab1.id_dp,
                tab1.id_tipo_doc,
                tab1.num_doc,
                tab3.nombre_apellido,
                tab1.id_anhos as anho_estado_func,
                tab1.id_meses as meses_estado_func,
                tab1.periodo as id_periodo

                FROM no_nombramiento_v nom

                --LEFT JOIN no_estado_func_v tab1 ON nom.num_doc = tab1.num_doc
                left join (
                      SELECT
                       aut.*,
                       ROW_NUMBER() OVER (
                        partition by aut.num_doc
                        ORDER BY aut.id_anhos desc, aut.id_meses desc, aut.actual desc
                       ) AS rnn
                      from no_estado_func_v aut

                        JOIN no_periodo tab2
                        ON tab2.id_periodo = aut.periodo
                        AND tab2.id_anhos = aut.id_anhos

                      where
                      aut.id_anhos = $P{id_anhos}
                      and tab2.id_tipo_periodo = 1
                )tab1
                ON nom.num_doc = tab1.num_doc
                and tab1.rnn = 1

                JOIN no_periodo tab2
                ON tab2.id_periodo = tab1.periodo
                AND tab2.id_anhos = tab1.id_anhos

                LEFT JOIN no_datos_funcionario_v tab3 ON tab3.num_doc=tab1.num_doc

                WHERE
                /*tab1.id_meses = 12
                AND*/ tab2.id_tipo_periodo = 1
                AND tab1.id_anhos = $P{id_anhos}
                --AND tab1.actual = 1
                and nom.fecha_retiro is null
                and (nom.fecha_ingreso  >= to_date( $P{id_anhos} || '-12-31','yyyy-mm-dd'))

                and tab1.num_doc not in (

                    SELECT
                    tab1.num_doc

                    FROM no_estado_func_v tab1

                    JOIN no_periodo tab2
                    ON tab2.id_periodo = tab1.periodo
                    AND tab2.id_anhos = tab1.id_anhos

                    LEFT JOIN no_datos_funcionario_v tab3 ON tab3.num_doc=tab1.num_doc

                    LEFT JOIN no_nombramiento_v nom ON nom.num_doc = tab1.num_doc

                    WHERE
                    tab1.id_meses = 12
                    AND tab2.id_tipo_periodo = 1
                    AND tab1.id_anhos = $P{id_anhos}
                    AND tab1.actual = 1
                    and (nom.fecha_retiro is null or nom.fecha_termina > to_date( $P{id_anhos} || '12-31','yyyy-mm-dd'))

                )

            )tab1
            ON tab0.id_dp = tab1.id_dp

            LEFT JOIN(
                SELECT
                tab1.id_dp,
                tab1.id_tipo_doc,
                tab1.num_doc,
                tab3.nombre_apellido,
                tab1.id_anhos as anho_estado_func,
                tab1.id_meses as meses_estado_func,
                tab1.periodo as id_periodo

                FROM no_estado_func_v tab1

                JOIN no_periodo tab2
                ON tab2.id_periodo = tab1.periodo
                AND tab2.id_anhos = tab1.id_anhos

                LEFT JOIN no_datos_funcionario_v tab3 ON tab3.num_doc=tab1.num_doc

                LEFT JOIN no_nombramiento_v nom ON nom.num_doc = tab1.num_doc

                WHERE
                tab1.id_meses = 12
                AND tab2.id_tipo_periodo = 1
                AND tab1.id_anhos = $P{id_anhos} - (case when $P{entidad_cliente} in (8) then 1 else 0 end)
                AND tab1.actual = 1
                and (nom.fecha_retiro is null or nom.fecha_retiro >= to_date( $P{id_anhos} || '12-31','yyyy-mm-dd'))

            )antvig
            ON tab0.id_dp = antvig.id_dp
            and tab1.num_doc = antvig.num_doc

            left join(

              select
              agrup.id_concep_nomina,
              agrup.id_agrup_concepto,
              agrup.tipo_valor
              from no_agrup_deta agrup

              where
              agrup.id_agrup_concepto = 126

              union

              select
              agrup.id_concep_nomina,
              agrup.id_agrup_concepto,
              'Y' as tipo_valor
              from no_agrup_deta agrup

              where
              agrup.id_agrup_concepto = (select id_agrup_cesmen from no_param_concep where id_param_concep = 1)

              union

              select
              agrup.id_concep_nomina,
              agrup.id_agrup_concepto,
              'Z' as tipo_valor
              from no_agrup_deta agrup

              where
              agrup.id_agrup_concepto = (select id_agrup_cesanu from no_param_concep where id_param_concep = 1)

            )tab2 on tab2.id_agrup_concepto != 0

            left join no_concep_nomina tab3 on tab3.id_concep_nomina=tab2.id_concep_nomina

            LEFT JOIN no_param_concep tab4 ON tab4.id_param_concep = 1

            left join (

                select distinct
                liq.num_doc,
                liq.id_concep_nomina
                from no_liquida_nomina liq
                left join no_periodo per
                on per.id_periodo = liq.id_periodo
                where
                per.id_anhos = $P{id_anhos}

                union

                select distinct
                liq.num_doc,
                    (select
                    max(agrup.id_concep_nomina)
                    from no_agrup_deta agrup
                    where
                    agrup.id_agrup_concepto = (select id_agrup_cesmen from no_param_concep where id_param_concep = 1) ) as id_concep_nomina
                from no_liquida_nomina liq
                left join no_periodo per
                on per.id_periodo = liq.id_periodo
                where
                per.id_anhos = $P{id_anhos}

            )liq
            on liq.num_doc = tab1.num_doc
            and liq.id_concep_nomina = tab2.id_concep_nomina

            where
            1 = 1
            $P!{wherePlanta}

        )tab0

        /*where tab0.num_doc = 0*/

        group by
        tab0.id_dp,
        tab0.codigo,
        tab0.id_comp_es,
        tab0.id_planta_p,
        tab0.codigo_concepto,
        tab0.denominacion_comp,
        tab0.grado_comp,
        tab0.codigo_tipo_vinc,
        tab0.num_doc,
        tab0.nombre_apellido

    )tab0

    LEFT JOIN no_nombramiento_v nom
    ON nom.num_doc = tab0.num_doc

    where
    1 = 1
    $P!{wherePlanta}
    $P!{whereComponenteEscala}
    and ( case when tag_orden = 2 and tab0.num_doc is null then 0 else 1 end ) = 1

)tab0

group by
--tab0.codigo
tab0.id_comp_es,
tab0.id_planta_p,
tab0.codigo_concepto,
tab0.denominacion_comp,
tab0.grado_comp,
tab0.codigo_tipo_vinc

ORDER BY
min(tab0.codigo),
tab0.denominacion_comp,
tab0.grado_comp,
tab0.codigo_tipo_vinc]]>
	</queryString>
	<field name="CODIGO" class="java.lang.String"/>
	<field name="ID_COMP_ES" class="java.math.BigDecimal"/>
	<field name="ID_PLANTA_P" class="java.math.BigDecimal"/>
	<field name="CODIGO_CONCEPTO" class="java.lang.String"/>
	<field name="DENOMINACION_COMP" class="java.lang.String"/>
	<field name="GRADO_COMP" class="java.lang.String"/>
	<field name="CARGO_APROBADO" class="java.math.BigDecimal"/>
	<field name="CARGO_PROVISTO" class="java.math.BigDecimal"/>
	<field name="CODIGO_TIPO_VINC" class="java.lang.String"/>
	<field name="NUM_DOC" class="java.lang.String"/>
	<field name="NOMBRE_APELLIDO" class="java.lang.String"/>
	<field name="VAL_CONCEP_BASICA" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_ADICIONAL_AB" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_GASTO_REPRE" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_GASTO_REPRE" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMTEC_SAL" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMTEC_SAL" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMGEST" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMGEST" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMLOC" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMLOC" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMCOOR" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMCOOR" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMRIES" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMRIES" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMAEXTRA" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMAEXTRA" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMALT" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMALT" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_SUBALIM" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_SUBALIM" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_AUXTRANS" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_AUXTRANS" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_AUX_CONECT" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_AUX_CONECT" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMANT" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMANT" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMSERV" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMSERV" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMNAV" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMNAV" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_BONIF" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_BONIF" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_BONFREC" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_BONFREC" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMVAC" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMVAC" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_INDEM_VAC" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_PRIMACT" class="java.math.BigDecimal"/>
	<field name="FACTOR_CONCEP_PRIMACT" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_OTRAPRIM_SAL" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_OTRAPRIM_NO_SAL" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_CESANU" class="java.math.BigDecimal"/>
	<field name="VAL_CONCEP_CESANUAL" class="java.math.BigDecimal"/>
	<field name="VAL_INT_CESANU" class="java.math.BigDecimal"/>
	<field name="FECHA_INGRESO" class="java.sql.Timestamp"/>
	<field name="FECHA_RETIRO" class="java.sql.Timestamp"/>
	<variable name="consecutivo" class="java.lang.Integer" resetType="Column" calculation="Count">
		<variableExpression><![CDATA[$F{CODIGO}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement x="330" y="0" width="925" height="38"/>
				<textElement textAlignment="Center" verticalAlignment="Bottom" markup="none">
					<font fontName="SansSerif" size="14" isBold="true"/>
				</textElement>
				<text><![CDATA[Sistema General de Nómina
Informe Costos - CGN Consolidado Anual]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="10" width="190" height="40"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:LogoEmpresa003.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement mode="Opaque" x="1255" y="25" width="140" height="13" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[Fecha de Impresión:]]></text>
			</staticText>
			<textField pattern="dd-MMM-yyyy   hh:mm aaa">
				<reportElement x="1255" y="38" width="140" height="13"/>
				<box rightPadding="3"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="330" y="38" width="925" height="22"/>
				<textElement textAlignment="Center">
					<font size="12"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Vigencia "+$P{id_anhos}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="21" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="25" splitType="Stretch">
			<staticText>
				<reportElement mode="Opaque" x="75" y="0" width="55" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CONCEPTO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="130" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CONSECUTIVO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="200" y="0" width="130" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[DENOMINACION DEL CARGO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="330" y="0" width="40" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[GRADO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="0" y="0" width="20" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="370" y="0" width="60" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CARGOS APROBADOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="430" y="0" width="60" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CARGOS PROVISTOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="490" y="0" width="65" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[TIPO DE VINCULACION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="555" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[ASIGNACION BASICA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="625" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[GASTOS REPRESENTACION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="695" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA TECNICA ]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="765" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA DE GESTION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="835" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA DE LOCALIZACION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="905" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA DE COORDINACION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1045" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA EXTRAORDINARIA]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1115" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA DE ALTO MANDO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="975" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA RIESGO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1185" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA O SUBSID ALIMENTACION]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1255" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[AUXILIO DE TRANSPORTE Y CONECTIVIDAD]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1325" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA DE ANTIGUEDAD]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1395" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA DE SERVICIOS ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1465" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA DE NAVIDAD ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1535" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[BONIF POR SERVICIOS ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1605" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[BONIF DE RECREACION ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1815" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[OTRAS PRIMAS FACTOR SALARIAL ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1885" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[OTRAS PRIMAS FACTOR NO SALARIAL ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1675" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA DE VACACIONES ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1745" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[PRIMA DE ACTIVIDAD ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1955" y="0" width="70" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CESANTIAS ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="2025" y="0" width="75" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[INTERESES SOBRE CESANTIAS ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="20" y="0" width="55" height="25" forecolor="#000000" backcolor="#88C2F9"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="8" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CODIGO]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="75" y="0" width="55" height="20"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_CONCEPTO}]]></textFieldExpression>
			</textField>
			<textField pattern="000">
				<reportElement stretchType="RelativeToTallestObject" x="130" y="0" width="70" height="20"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.Number"><![CDATA[$V{REPORT_COUNT}-1]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="200" y="0" width="130" height="20"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{DENOMINACION_COMP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="330" y="0" width="40" height="20"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{GRADO_COMP}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" mode="Transparent" x="0" y="0" width="20" height="20" forecolor="#000000" backcolor="#FFFFFF"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="7" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["D"]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="370" y="0" width="60" height="20"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CARGO_APROBADO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="430" y="0" width="60" height="20"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CARGO_PROVISTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="490" y="0" width="65" height="20"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO_TIPO_VINC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="555" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_BASICA}+$F{VAL_CONCEP_ADICIONAL_AB}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="625" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_GASTO_REPRE}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="695" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMTEC_SAL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="765" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMGEST}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="835" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMLOC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="905" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMCOOR}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="975" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMRIES}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1045" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMAEXTRA}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1115" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMALT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1185" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_SUBALIM}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1255" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_AUXTRANS} + $F{VAL_CONCEP_AUX_CONECT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1325" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMANT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1395" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMSERV}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1465" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMNAV}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1535" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_BONIF}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1605" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_BONFREC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1675" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMVAC}+$F{VAL_CONCEP_INDEM_VAC}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1745" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_PRIMACT}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1815" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_OTRAPRIM_SAL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1885" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_OTRAPRIM_NO_SAL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="2025" y="0" width="75" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_INT_CESANU}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1955" y="0" width="70" height="20"/>
				<box leftPadding="0" rightPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{VAL_CONCEP_CESANU}+$F{VAL_CONCEP_CESANUAL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement stretchType="RelativeToTallestObject" x="20" y="0" width="55" height="20"/>
				<box leftPadding="2">
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="7"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{CODIGO}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="23" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="636" y="12" width="89" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Página "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement mode="Opaque" x="726" y="12" width="60" height="12" forecolor="#575757" backcolor="#FFFFFF"/>
				<textElement verticalAlignment="Middle" rotation="None" markup="none">
					<font fontName="SansSerif" size="6" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="636" y="0" width="150" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Nómina]]></text>
			</staticText>
		</band>
	</pageFooter>
	<summary>
		<band height="25" splitType="Stretch"/>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="1395" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
