900: p_grade_ladder_pgm_id number) return varchar2 is
901: --
902: cursor csr_lookup is
903: select name 904: from ben_pgm_f pgm 905: ,fnd_sessions s
906: where pgm_id = p_grade_ladder_pgm_id
907: and s.effective_date between
908: pgm.effective_start_date and pgm.effective_end_date