APPS.BEN_CON_LER dependencies on BEN_LER_F

Line 41: from ben_ler_f ler

37: select ler.ler_id
38: , ler.typ_cd
39: , ler.ocrd_dt_det_cd
40: , ler.effective_start_date -- Added for bug 3105696
41: from ben_ler_f ler
42: where ler.business_group_id = p_new.business_group_id
43: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
44: and l_session_date
45: between ler.effective_start_date

Line 125: l_typ_cd ben_ler_f.typ_cd%type ;

121: and effective_end_date; */ -- commented for 3518038
122:
123: l_changed BOOLEAN;
124: l_ler_id NUMBER;
125: l_typ_cd ben_ler_f.typ_cd%type ;
126: l_column ben_rltd_per_chg_cs_ler_f.source_column%type; -- VARCHAR2(30);
127: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type; -- VARCHAR2(30);
128: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
129: l_ocrd_dt_cd VARCHAR2(30);