APPS.BEN_PAC_LER dependencies on BEN_LER_F

Line 285: from ben_ler_f ler

281: cursor get_ler(l_status varchar2) is
282: select ler.ler_id
283: , ler.typ_cd
284: , ler.ocrd_dt_det_cd
285: from ben_ler_f ler
286: where ler.business_group_id = p_new.business_group_id
287: and l_session_date between ler.effective_start_date and ler.effective_end_date
288: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )
289: and ((exists

Line 378: l_typ_cd ben_ler_f.typ_cd%type ;

374: l_context varchar2(30);
375: --
376: l_changed BOOLEAN;
377: l_ler_id NUMBER;
378: l_typ_cd ben_ler_f.typ_cd%type ;
379: l_ocrd_dt_cd VARCHAR2(30);
380: l_column ben_rltd_per_chg_cs_ler_f.source_column%type;
381: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
382: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;