<?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" language="groovy" pageWidth="2120" pageHeight="612" orientation="Landscape" columnWidth="2080" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.3310000000000024"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.jasperserver.reportUnit" value="/reports/nomina/estado_planta_func"/>
	<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>
	<queryString>
		<![CDATA[select
tab0.*
from (

    select
    1 as tag_orden,
    '90' as codigo_concepto,
    'NA' as denominacion_comp,
    'NA' as grado_comp,
    sum(tab0.cargo_aprobado) as cargo_aprobado,
    sum(tab0.cargo_provisto) as cargo_provisto,
    'V0' as codigo_tipo_vinc,

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

    from(

        select
        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 tab0.valor else 0 end) as val_concep_basica,
        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_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_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_cesanu = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_cesanu,
        --0 as val_concep_cesanu,
        sum(case when tab0.id_concep_nomina not in (tab0.id_concep_basica,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_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_primact,tab0.id_concep_bonif
                                         ,tab0.id_concep_cesanu
                                         ) 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_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_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_primact,tab0.id_concep_bonif
                                         ,tab0.id_concep_cesanu
                                         ) 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,

            tab1.num_doc as num_doc,
            tab1.nombre_apellido,
            case
                when ajus.id_concep_nomina is not null then ajus.id_concep_nomina
                when rein.id_concep_nomina is not null then rein.id_concep_nomina
                else tab1.id_concep_nomina end as id_concep_nomina,
            tab1.valor_liquidado as valor,

            tab3.factor_salarial,
            nvl(tab4.id_concep_basica,0) as id_concep_basica,
            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_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_primact,0) as id_concep_primact,
            nvl(tab4.id_concep_bonif,0) as id_concep_bonif,
            (select
                    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_cesanu

            from no_dp_v tab0

            left join(

                select
                liq.id_liquida_nomina as tag_id_union,
                liq.id_concep_nomina,
                case when agrup.operador = 1 then (1) else (-1) end * liq.valor_liquidado as valor_liquidado,
                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_liquida_nomina liq

                join no_estado_func_v tab1
                on  liq.num_doc = tab1.num_doc
                and liq.id_tipo_doc = tab1.id_tipo_doc
                and liq.id_periodo = tab1.periodo

                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
                and tab3.id_tipo_doc = tab1.id_tipo_doc

                join (

                    select
                    1 as operador,
                    agrup.id_concep_nomina
                    from no_agrup_deta agrup

                    where
                    agrup.id_agrup_concepto = 111

                    union

                    select
                    1 as operador,
                    con.id_concep_ajuste
                    from no_agrup_deta agrup
                    join no_concep_nomina con
                    on con.id_concep_nomina = agrup.id_concep_nomina

                    where
                    agrup.id_agrup_concepto = 111

                    union

                    select
                    0 as operador,
                    con.id_concep_rein
                    from no_agrup_deta agrup
                    join no_concep_nomina con
                    on con.id_concep_nomina = agrup.id_concep_nomina

                    where
                    agrup.id_agrup_concepto = 111

                )agrup
                on agrup.id_concep_nomina = liq.id_concep_nomina

                where
                tab1.id_anhos = $P{id_anhos}

                union

                select
                ces.id_cesantia as tag_id_union,
                (
                    select
                    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,
                ces.valor_consolidado as valor_liquidado,
                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_cesantia ces

                join no_estado_func_v tab1
                on  ces.num_doc = tab1.num_doc
                and ces.id_tipo_doc = tab1.id_tipo_doc
                and ces.id_periodo = tab1.periodo

                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
                and tab3.id_tipo_doc = tab1.id_tipo_doc

                where
                tab1.id_anhos = $P{id_anhos}
                and ces.valor_consolidado != 0

            )tab1
            on tab0.id_dp = tab1.id_dp

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

            left join no_concep_nomina ajus
            on ajus.id_concep_ajuste = tab1.id_concep_nomina

            left join no_concep_nomina rein
            on rein.id_concep_rein = tab1.id_concep_nomina

            left join no_param_concep tab4
            on tab4.id_param_concep = 1

        )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

    )tab0

    where
    1 = 1
    $P!{wherePlanta}
    $P!{whereComponenteEscala}
    /*
    group by
    tab0.codigo_concepto,
    tab0.denominacion_comp,
    tab0.grado_comp,
    tab0.codigo_tipo_vinc*/

    union

    select
    2 as tag_orden,
    tab0.codigo_concepto,
    tab0.denominacion_comp,
    tab0.grado_comp,
    sum(tab0.cargo_aprobado) as cargo_aprobado,
    sum(tab0.cargo_provisto) as cargo_provisto,
    tab0.codigo_tipo_vinc,

    sum(tab0.val_concep_basica) as val_concep_basica,
    sum(tab0.val_concep_gasto_repre) as val_concep_gasto_repre,
    max(tab0.factor_concep_gasto_repre) as factor_concep_gasto_repre,
    sum(tab0.val_concep_primtec_sal) as val_concep_primtec_sal,
    max(tab0.factor_concep_primtec_sal) as factor_concep_primtec_sal,
    sum(tab0.val_concep_primgest) as val_concep_primgest,
    max(tab0.factor_concep_primgest) as factor_concep_primgest,
    sum(tab0.val_concep_primloc) as val_concep_primloc,
    max(tab0.factor_concep_primloc) as factor_concep_primloc,
    sum(tab0.val_concep_primcoor) as val_concep_primcoor,
    max(tab0.factor_concep_primcoor) as factor_concep_primcoor,
    sum(tab0.val_concep_primries) as val_concep_primries,
    max(tab0.factor_concep_primries) as factor_concep_primries,
    sum(tab0.val_concep_primaextra) as val_concep_primaextra,
    max(tab0.factor_concep_primaextra) as factor_concep_primaextra,
    sum(tab0.val_concep_primalt) as val_concep_primalt,
    max(tab0.factor_concep_primalt) as factor_concep_primalt,
    sum(tab0.val_concep_subalim) as val_concep_subalim,
    max(tab0.factor_concep_subalim) as factor_concep_subalim,
    sum(tab0.val_concep_auxtrans) as val_concep_auxtrans,
    max(tab0.factor_concep_auxtrans) as factor_concep_auxtrans,
    sum(tab0.val_concep_primant) as val_concep_primant,
    max(tab0.factor_concep_primant) as factor_concep_primant,
    sum(tab0.val_concep_primserv) as val_concep_primserv,
    max(tab0.factor_concep_primserv) as factor_concep_primserv,
    sum(tab0.val_concep_primnav) as val_concep_primnav,
    max(tab0.factor_concep_primnav) as factor_concep_primnav,
    sum(tab0.val_concep_bonif) as val_concep_bonif,
    max(tab0.factor_concep_bonif) as factor_concep_bonif,
    sum(tab0.val_concep_bonfrec) as val_concep_bonfrec,
    max(tab0.factor_concep_bonfrec) as factor_concep_bonfrec,
    sum(tab0.val_concep_primvac) as val_concep_primvac,
    max(tab0.factor_concep_primvac) as factor_concep_primvac,
    sum(tab0.val_concep_primact) as val_concep_primact,
    max(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,
    0 as val_int_cesanu

    from(

        select
        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 tab0.valor else 0 end) as val_concep_basica,
        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_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_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_cesanu = tab0.id_concep_nomina then tab0.valor else 0 end) as val_concep_cesanu,
        --0 as val_concep_cesanu,
        sum(case when tab0.id_concep_nomina not in (tab0.id_concep_basica,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_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_primact,tab0.id_concep_bonif
                                         ,tab0.id_concep_cesanu
                                         ) 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_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_primant,tab0.id_concep_primserv,tab0.id_concep_primnav,tab0.id_concep_bonfrec,tab0.id_concep_primvac,tab0.id_concep_primact,tab0.id_concep_bonif
                                         ,tab0.id_concep_cesanu
                                         ) 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,

            tab1.num_doc as num_doc,
            tab1.nombre_apellido,
            case
                when ajus.id_concep_nomina is not null then ajus.id_concep_nomina
                when rein.id_concep_nomina is not null then rein.id_concep_nomina
                else tab1.id_concep_nomina end as id_concep_nomina,
            tab1.valor_liquidado as valor,

            tab3.factor_salarial,
            nvl(tab4.id_concep_basica,0) as id_concep_basica,
            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_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_primact,0) as id_concep_primact,
            nvl(tab4.id_concep_bonif,0) as id_concep_bonif,
            (select
                    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_cesanu

            from no_dp_v tab0

            left join(

                select
                liq.id_liquida_nomina as tag_id_union,
                liq.id_concep_nomina,
                case when agrup.operador = 1 then (1) else (-1) end * liq.valor_liquidado as valor_liquidado,
                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_liquida_nomina liq

                join no_estado_func_v tab1
                on  liq.num_doc = tab1.num_doc
                and liq.id_tipo_doc = tab1.id_tipo_doc
                and liq.id_periodo = tab1.periodo

                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
                and tab3.id_tipo_doc = tab1.id_tipo_doc

                join (

                    select
                    1 as operador,
                    agrup.id_concep_nomina
                    from no_agrup_deta agrup

                    where
                    agrup.id_agrup_concepto = 111

                    union

                    select
                    1 as operador,
                    con.id_concep_ajuste
                    from no_agrup_deta agrup
                    join no_concep_nomina con
                    on con.id_concep_nomina = agrup.id_concep_nomina

                    where
                    agrup.id_agrup_concepto = 111

                    union

                    select
                    0 as operador,
                    con.id_concep_rein
                    from no_agrup_deta agrup
                    join no_concep_nomina con
                    on con.id_concep_nomina = agrup.id_concep_nomina

                    where
                    agrup.id_agrup_concepto = 111

                )agrup
                on agrup.id_concep_nomina = liq.id_concep_nomina

                where
                tab1.id_anhos = $P{id_anhos}

                union

                select
                ces.id_cesantia as tag_id_union,
                (
                    select
                    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,
                ces.valor_consolidado as valor_liquidado,
                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_cesantia ces

                join no_estado_func_v tab1
                on  ces.num_doc = tab1.num_doc
                and ces.id_tipo_doc = tab1.id_tipo_doc
                and ces.id_periodo = tab1.periodo

                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
                and tab3.id_tipo_doc = tab1.id_tipo_doc

                where
                tab1.id_anhos = $P{id_anhos}
                and ces.valor_consolidado != 0

            )tab1
            on tab0.id_dp = tab1.id_dp

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

            left join no_concep_nomina ajus
            on ajus.id_concep_ajuste = tab1.id_concep_nomina

            left join no_concep_nomina rein
            on rein.id_concep_rein = tab1.id_concep_nomina

            left join no_param_concep tab4
            on tab4.id_param_concep = 1

        )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

    )tab0

    where
    1 = 1
    $P!{wherePlanta}
    $P!{whereComponenteEscala}

    group by
    tab0.codigo_concepto,
    tab0.denominacion_comp,
    tab0.grado_comp,
    tab0.codigo_tipo_vinc

)tab0

order by
tab0.tag_orden,
tab0.codigo_concepto,
tab0.denominacion_comp,
tab0.grado_comp desc,
tab0.codigo_tipo_vinc]]>
	</queryString>
	<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="VAL_CONCEP_BASICA" 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_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_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_INT_CESANU" class="java.math.BigDecimal"/>
	<variable name="consecutivo" class="java.lang.Integer" resetType="None" incrementType="Column" calculation="Count">
		<variableExpression><![CDATA[]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="60" splitType="Stretch">
			<staticText>
				<reportElement x="275" y="0" width="1485" 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]]></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="1830" y="25" width="180" 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="1830" y="38" width="180" 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="275" y="38" width="1485" height="22"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="12" isBold="true"/>
				</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="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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CONCEPTO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="75" 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[CONSECUTIVO]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="145" 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="7" 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="275" 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="7" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="315" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CARGOS APROBADOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="375" 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="7" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/>
				</textElement>
				<text><![CDATA[CARGOS PROVISTOS]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="435" 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="7" 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="500" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="570" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="640" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="710" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="780" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="850" 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 ANUAL ]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="990" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1060" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="920" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1130" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1200" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1270" 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 ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1340" 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="1410" 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="1480" 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="1550" 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="1620" 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="1690" 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="1830" 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="1900" 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[INTERESES SOBRE CESANTIAS ANUAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1970" y="0" width="110" 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[TOTAL]]></text>
			</staticText>
			<staticText>
				<reportElement mode="Opaque" x="1760" 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 ANUAL]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="20" splitType="Stretch">
			<textField>
				<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_CONCEPTO}]]></textFieldExpression>
			</textField>
			<textField pattern="000">
				<reportElement stretchType="RelativeToTallestObject" x="75" 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 isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="145" 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="275" 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="315" 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.math.BigDecimal"><![CDATA[$F{CARGO_APROBADO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="375" 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.math.BigDecimal"><![CDATA[$F{CARGO_PROVISTO}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="435" 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="500" 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}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="570" 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="640" 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="710" 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="780" 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="850" 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="920" 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="990" 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="1060" 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="1130" 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="1200" 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}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1270" 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="1340" 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="1410" 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="1480" 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="1550" 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="1620" 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}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1690" 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="1900" 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_INT_CESANU}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1830" 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}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1970" y="0" width="110" 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_GASTO_REPRE}+$F{VAL_CONCEP_PRIMTEC_SAL}+$F{VAL_CONCEP_PRIMGEST}+$F{VAL_CONCEP_PRIMLOC}+$F{VAL_CONCEP_PRIMCOOR}+$F{VAL_CONCEP_PRIMRIES}+$F{VAL_CONCEP_PRIMAEXTRA}+$F{VAL_CONCEP_PRIMALT}+$F{VAL_CONCEP_SUBALIM}+$F{VAL_CONCEP_AUXTRANS}+$F{VAL_CONCEP_PRIMANT}+$F{VAL_CONCEP_PRIMSERV}+$F{VAL_CONCEP_PRIMNAV}+$F{VAL_CONCEP_BONIF}+$F{VAL_CONCEP_BONFREC}+$F{VAL_CONCEP_PRIMVAC}+$F{VAL_CONCEP_PRIMACT}+$F{VAL_CONCEP_OTRAPRIM_SAL}+$F{VAL_CONCEP_OTRAPRIM_NO_SAL}+$F{VAL_CONCEP_CESANU}+$F{VAL_INT_CESANU}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToTallestObject" x="1760" 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}+$F{VAL_CONCEP_OTRAPRIM_NO_SAL}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="13" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="10" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="25" splitType="Stretch">
			<textField>
				<reportElement mode="Opaque" x="945" y="12" width="45" 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="990" y="12" width="70" 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="945" y="0" width="115" height="12" forecolor="#575757"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="6"/>
				</textElement>
				<text><![CDATA[Websafi - Nómina]]></text>
			</staticText>
		</band>
	</summary>
	<noData>
		<band height="20">
			<staticText>
				<reportElement x="0" y="0" width="2010" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font isBold="true"/>
				</textElement>
				<text><![CDATA[No hay objetos a mostrar.]]></text>
			</staticText>
		</band>
	</noData>
</jasperReport>
