APPS.BEN_PPR_LER dependencies on BEN_LER_F

Line 21: from ben_ler_f ler

17: cursor get_ler(l_status varchar2) is
18: select ler.ler_id
19: , ler.typ_cd
20: , ler.ocrd_dt_det_cd
21: from ben_ler_f ler
22: where
23: ler.business_group_id = p_new.business_group_id
24: and l_session_date between ler.effective_start_date and ler.effective_end_date
25: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )

Line 118: l_typ_cd ben_ler_f.typ_cd%type ;

114: l_changed BOOLEAN;
115: l_lf_evt_ocrd_date DATE;
116: l_effective_start_date DATE;
117: l_ler_id NUMBER;
118: l_typ_cd ben_ler_f.typ_cd%type ;
119: l_ovn NUMBER;
120: l_ptnl_id NUMBER;
121: l_hld_person_id NUMBER;
122: l_ocrd_dt_cd VARCHAR2(30);