784: p_grade_ladder_id number) return varchar2 is
785: --
786: cursor csr_lookup is
787: select name
788: from ben_pgm_f
789: where pgm_id = p_grade_ladder_id;
790: --
791: v_meaning ben_pgm_f.name%TYPE := null;
792: --
787: select name
788: from ben_pgm_f
789: where pgm_id = p_grade_ladder_id;
790: --
791: v_meaning ben_pgm_f.name%TYPE := null;
792: --
793: begin
794: --
795: -- Only open the cursor if the parameter is going to retrieve anything