APPS.BEN_ECD_LER dependencies on BEN_LER_F

Line 34: from ben_ler_f ler

30: cursor get_ler(l_status varchar2) is
31: select ler.ler_id
32: , ler.typ_cd
33: , ler.ocrd_dt_det_cd
34: from ben_ler_f ler
35: where ler.business_group_id = p_new.business_group_id
36: and l_session_date between ler.effective_start_date
37: and ler.effective_end_date -- For Bug 3299709
38: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )

Line 117: l_typ_cd ben_ler_f.typ_cd%type ;

113: order by person_id;
114: --
115: l_changed BOOLEAN;
116: l_ler_id NUMBER;
117: l_typ_cd ben_ler_f.typ_cd%type ;
118: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
119: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
120: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
121: l_ocrd_dt_cd VARCHAR2(30);