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.ChannelErrorCode;
import com.eactive.eai.data.jpa.BaseRepository;

public interface ChannelErrorCodeLoaderRepository extends BaseRepository<ChannelErrorCode, String> {

	   @Query("from ChannelErrorCode where err_tlg_lan_dscd ='KOR' and err_cd_us_yn ='Y' and  err_cd_apl_dt <= :pNow and del_yn = 'N' order by std_err_cd ")
	   List<ChannelErrorCode> selectAll(@Param("pNow")String now);
}
