cind

(SELECT ( CAST( (	(SELECT SUM(POL_PRIMA) FROM cind_base_polizas_tmp A
																WHERE A.pol_id_agente IN(
																									SELECT pol_id_agente
																									FROM cind_base_polizas_tmp
																									WHERE pol_id_supervisor_vigente = IDSUPERVISOR
																									GROUP BY pol_id_agente
																									HAVING SUM(POL_PRIMA) >= 75.000
																								)
															)	* A.BON_PORCENTAJE_CALCULO ) / 100 AS NUMERIC (19,4)) * @UF )
															/
																(SELECT (X.BON_PORC_BONO / 100)
																FROM cind_bono_productividad_unidad_persistencia X
																WHERE DATEDIFF(MONTH, FECHAINGRESOSUP, DATEADD(MONTH, -1, @FECHAPERIODO)) BETWEEN X.BON_MES_DESDE AND X.BON_MES_HASTA
																AND	CAST( ((( PRIMAPERSISTENCIA_VIGENTE)   / TOTALGENERALPERSISTENCIA) * 100 ) AS NUMERIC(19,4) )
																BETWEEN X.BON_PERSISTENCIA_DESDE AND X.BON_PERSISTENCIA_HASTA
																AND PERIODODELPROCESO = ALGO
																)




												FROM cind_bono_productividad_unidad A
												WHERE (SELECT COUNT(1) FROM cind_jerarquia WHERE jer_usu_id_padre = IDSUPERVISOR and jer_nivel = 3 AND PERIODODELPROCESO = ALGO)
												BETWEEN  A.BON_TOTAL_ASESOR_DESDE AND A.BON_TOTAL_ASESOR_HASTA
												AND
												(
													SELECT TOP 1 ROW_NUMBER() OVER(ORDER BY pol_id_agente ASC)
													FROM cind_base_polizas_tmp
													WHERE pol_id_supervisor_vigente = IDSUPERVISOR
													GROUP BY pol_id_agente
													HAVING SUM(POL_PRIMA) >= 75.000
													ORDER BY ROW_NUMBER() OVER(ORDER BY pol_id_agente DESC)
												)
												BETWEEN A.BON_ASESOR_DESDE AND A.BON_ASESOR_HASTA
												AND PERIODODELPROCESO = ALGO
											) AS BONO_DE_PRODUCTIVIDAD_DE_LA_UNIDAD