DBA Data[Home] [Help]

APPS.PER_QH_POPULATE dependencies on BEN_PGM_F

Line 283: l_grade_ladder_name ben_pgm_f.name%type;

279: (p_grade_ladder_pgm_id number
280: ,p_effective_date date) return varchar2 is
281: --
282: l_proc varchar2(72) :=g_package||'get_grade_ladder';
283: l_grade_ladder_name ben_pgm_f.name%type;
284: --
285: cursor csr_grade_ladder is
286: select name
287: from ben_pgm_f

Line 287: from ben_pgm_f

283: l_grade_ladder_name ben_pgm_f.name%type;
284: --
285: cursor csr_grade_ladder is
286: select name
287: from ben_pgm_f
288: where pgm_id = p_grade_ladder_pgm_id
289: and p_effective_date
290: between effective_start_date and effective_end_date;
291: --