272: (p_grade_ladder_pgm_id number
273: ,p_effective_date date) return varchar2 is
274: --
275: l_proc varchar2(72) :=g_package||'get_grade_ladder';
276: l_grade_ladder_name ben_pgm_f.name%type;
277: --
278: cursor csr_grade_ladder is
279: select name
280: from ben_pgm_f
276: l_grade_ladder_name ben_pgm_f.name%type;
277: --
278: cursor csr_grade_ladder is
279: select name
280: from ben_pgm_f
281: where pgm_id = p_grade_ladder_pgm_id
282: and p_effective_date
283: between effective_start_date and effective_end_date;
284: --