APPS.BEN_PTU_LER dependencies on BEN_LER_F

Line 31: from ben_ler_f ler

27: cursor get_ler(l_status varchar2) is
28: select ler.ler_id
29: , ler.typ_cd
30: , ler.ocrd_dt_det_cd
31: from ben_ler_f ler
32: where ler.business_group_id = l_business_group_id
33: and l_session_date
34: between ler.effective_start_date
35: and ler.effective_end_date

Line 115: l_typ_cd ben_ler_f.typ_cd%type ;

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