Replace sql queries with hql

[archit-1997]

Instead of using sql queries, replace them with hibernates own native hql i.e. hibernate query language.