31: p_ler_name IN VARCHAR2,
32: p_ler_id IN NUMBER,
33: p_bus_grp_id in number) IS
34: SELECT 1 35: FROM ben_ler_f_tl ler_tl, 36: ben_ler_f ler
37: WHERE upper(ler.name)= upper(p_ler_name)
38: AND ler.ler_id = ler_tl.ler_id
39: AND ler_tl.language = p_language