Experts Exchange connects you with the people and services you need so you can get back to work.
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
public List getLNSTrialExecute(Date CurrentworkDt, char siType, int prodId) throws MyException
Session session = HibernateUtil.getSession();
List<Object> lstAdvMaster = null;
lstAdvMaster = session.createSQLQuery("SELECT s.sim_branch_code, s.sim_product_id, c.cgl_desc as DrProdDesc, s.sim_account_no, " +
"s.sim_end_dt, s.sim_execution_day, s.sim_frequency, s.sim_branch_cd1, cb.ceb_branch_name, s.sim_product_id1, " +
"cgl.cgl_desc as CrProdDesc, s.sim_account_no_cr, s.sim_amount, s.sim_srno1, s.sim_next_exec_dt, s.si_status, " +
"s.sim_times_exec_mthly, s.sim_record_status FROM si_maintenance s INNER JOIN code_gl c ON (s.sim_product_id = c.cgl_code) " +
"INNER JOIN code_gl cgl ON (s.sim_product_id1 = cgl.cgl_code) INNER JOIN code_ebank cb ON (s.sim_branch_cd1 = cb.ceb_micr) " +
"WHERE s.sim_product_id1 = :prodId AND s.si_status IN ('C','I') AND s.sim_si_complete = :sicomplete AND s.sim_si_type = :siType AND " +
"s.sim_next_exec_dt <= :CurrentworkDt AND s.sim_record_status = 2").setParameter("siType", siType)
.setParameter("CurrentworkDt",CurrentworkDt).setParameter("sicomplete", 'N').setParameter("prodId", prodId).list();
catch (Exception e)
throw new MyException(e.getMessage());
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.
Premium members get this course for $24.99.
Premium members get this course for $37.50.
Premium members get this course for $159.20.
Premium members get this course for $31.25.
Premium members get this course for $79.20.