22: p_effective_date in date) return number is
23: --
24: cursor c1 is
25: select ler.ler_id 26: from ben_ler_f ler 27: where ler.business_group_id = p_business_group_id
28: and ler.typ_cd = 'DRVDAGE'
29: and p_effective_date
30: between ler.effective_start_date