DBA Data[Home] [Help]

APPS.BEN_PRV_LER dependencies on BEN_LER_F

Line 37: from ben_ler_f ler

33: --
34: cursor get_ler(l_status varchar2) is
35: select ler.ler_id,
36: ler.ocrd_dt_det_cd
37: from ben_ler_f ler
38: where ler.business_group_id = p_new.business_group_id
39: and l_session_date between ler.effective_start_date
40: and ler.effective_end_date -- For Bug 3299709
41: and ((exists