xmlns:xsi@H_403_2@="http://www.w3.org/2001/XMLSchema-instance"@H_403_2@ xmlns:context@H_403_2@="http://www.springframework.org/schema/context"@H_403_2@

xmlns:aop@H_403_2@="http://www.springframework.org/schema/aop"@H_403_2@ xmlns:tx@H_403_2@="http://www.springframework.org/schema/tx"@H_403_2@

xsi:schemaLocation@H_403_2@="http://www.springframework.org/schema/beans@H_403_2@

http://www.springframework.org/schema/beans/spring-beans-3.2.xsd

FROM FARE_BY_RULE_SEG

FROM FARE_BY_RULE_SEG

WHERE RULE_BTCH_SG IN (:batchSGs)

AND SEG_EFF_DT < :effectiveDate

WHERE RULE_BTCH_SG IN (:batchSGs)

AND SEG_EFF_DT < :effectiveDate

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd

http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd">@H_403_2@

<@H_403_2@import@H_403_2@ resource@H_403_2@="classpath:/spring/FilingTextHistoryQueries.xml"@H_403_2@ />@H_403_2@

<@H_403_2@bean@H_403_2@ id@H_403_2@="sqlFareByRuleIndexCnt"@H_403_2@ class@H_403_2@="java.lang.String"@H_403_2@>@H_403_2@

<@H_403_2@constructor-arg@H_403_2@ index@H_403_2@="0"@H_403_2@>@H_403_2@

<@H_403_2@value@H_403_2@>@H_403_2@

SELECT COUNT(*)

FROM FARE_BY_RULE_SEG

WHERE RULE_BTCH_SG IN (:batchSGs)

</@H_403_2@value@H_403_2@>@H_403_2@

</@H_403_2@constructor-arg@H_403_2@>@H_403_2@

</@H_403_2@bean@H_403_2@>@H_403_2@

<@H_403_2@bean@H_403_2@ id@H_403_2@="ruleFBRILt"@H_403_2@ class@H_403_2@="java.lang.String"@H_403_2@>@H_403_2@

<@H_403_2@constructor-arg@H_403_2@ index@H_403_2@="0"@H_403_2@ value@H_403_2@="#{sqlFareByRuleIndexCnt+' AND SEG_EFF_DT &lt; :effectiveDate'}"@H_403_2@/>@H_403_2@

</@H_403_2@bean@H_403_2@>@H_403_2@