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