Skip to content

B
business-java
Switch branch/tag
  1. 20 Sep, 2019 4 commits
  3. 19 Sep, 2019 35 commits
  5. 18 Sep, 2019 1 commit
    • ssalve's avatar
      Sarita : Committed on 18-09-2019 · 070ead6d
      ssalve authored 
      // 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
      070ead6d