APPS.BEN_PPF_LER dependencies on BEN_LER_F

Line 24: from ben_ler_f ler

20: cursor get_ler(l_status varchar2) is
21: select ler.ler_id
22: , ler.typ_cd
23: , ler.ocrd_dt_det_cd
24: from ben_ler_f ler
25: where ler.business_group_id = p_new.business_group_id
26: --3289596
27: and l_session_date between ler.effective_start_date
28: and ler.effective_end_date

Line 133: l_typ_cd ben_ler_f.typ_cd%Type ;

129: l_unprocd_dt DATE;
130: l_voidd_dt DATE;
131: l_ntfn_dt DATE;
132: l_ler_id NUMBER;
133: l_typ_cd ben_ler_f.typ_cd%Type ;
134: l_ovn NUMBER;
135: l_ptnl_id NUMBER;
136: l_hld_person_id NUMBER;
137: l_ocrd_dt_cd VARCHAR2(30);