// Modified by Piyush on 13/09/2019 [To consider IT Dates]
// sql = "SELECT ACCT_PRD,FR_DATE,TO_DATE FROM FINENT_ACCTPRD WHERE FIN_ENTITY = ? AND FR_DATE <= ? AND TO_DATE >= ? ";
// Modified by Piyush on 18/09/2019 [To consider IT Dates in where clause]
//sql = "SELECT ACCT_PRD,CASE WHEN IT_FR_DATE IS NULL THEN FR_DATE ELSE IT_FR_DATE END AS FR_DATE,CASE WHEN IT_TO_DATE IS NULL THEN TO_DATE ELSE IT_TO_DATE END AS TO_DATE FROM FINENT_ACCTPRD WHERE FIN_ENTITY = ? AND FR_DATE <= ? AND TO_DATE >= ? ";

** IT Flag is not getting updated on saving of payroll voucher considering the IT Dates - defined in FINENT_ACCTPRD/ACCTPRD for the eff_date mentioned in voucher
					
					

git-svn-id: http://15.206.35.175/svn/proteus/business-java/trunk@207626 ce508802-f39f-4f6c-b175-0d175dae99d5