APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_LER_F

Line 6166: from ben_ler_f ler

6162: ) return varchar2 is
6163:
6164: cursor c_ler_name is
6165: select ler.name
6166: from ben_ler_f ler
6167: where ler.ler_id = p_ler_id
6168: and p_effective_date between ler.effective_start_date
6169: and ler.effective_end_date;
6170:

Line 6171: l_ler_name ben_ler_f.name%type := null;

6167: where ler.ler_id = p_ler_id
6168: and p_effective_date between ler.effective_start_date
6169: and ler.effective_end_date;
6170:
6171: l_ler_name ben_ler_f.name%type := null;
6172:
6173: begin
6174: open c_ler_name;
6175: fetch c_ler_name into l_ler_name;