QBC

c.add(Restrictions.sqlRestriction("exists (SELECT p.loan_contract_no FROM crf_p2p_app_info p WHERE p.loan_contract_no={alias}.loan_contract_no)"));