APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_LER_F

Line 6165: from ben_ler_f ler

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

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

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