package com.eactive.eai.custom.stderrorcode.loader;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import com.eactive.eai.data.entity.custom.stderrorcode.StdErrorCode;
import com.eactive.eai.data.jpa.BaseRepository;

public interface StdErrorCodeLoaderRepository extends BaseRepository<StdErrorCode, String> {
	   
	   @Query("from StdErrorCode where std_err_cd_yn ='Y' and  err_tlg_lan_dscd ='KOR' and err_cd_us_yn ='Y' and err_cd_apl_dt <= :pNow and del_yn = 'N' order by err_cd ")
	   List<StdErrorCode> selectAll(@Param("pNow")String now);
}
