APPS.BEN_PER_ASG_EIT_LER dependencies on BEN_LER_F

Line 46: from ben_ler_f ler

42: cursor get_ler(l_status varchar2) is
43: select ler.ler_id
44: , ler.typ_cd
45: , ler.ocrd_dt_det_cd
46: from ben_ler_f ler
47: where ler.business_group_id = l_business_group_id------
48: and l_session_date between ler.effective_start_date
49: and ler.effective_end_date
50: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )

Line 147: l_typ_cd ben_ler_f.typ_cd%Type ;

143: l_proc varchar2(200) := 'ben_per_asg_eit_ler.ler_per_chk';
144: l_changed BOOLEAN;
145: l_effective_start_date DATE;
146: l_ler_id NUMBER;
147: l_typ_cd ben_ler_f.typ_cd%Type ;
148: l_ocrd_dt_cd VARCHAR2(30);
149: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
150: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;
151: l_per_info_chg_cs_ler_rl number;

Line 425: from ben_ler_f ler

421: cursor get_ler(l_status varchar2) is
422: select ler.ler_id
423: , ler.typ_cd
424: , ler.ocrd_dt_det_cd
425: from ben_ler_f ler
426: where ler.business_group_id = l_business_group_id------
427: and l_session_date between ler.effective_start_date
428: and ler.effective_end_date
429: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )

Line 534: l_typ_cd ben_ler_f.typ_cd%Type ;

530: --
531: l_proc varchar2(200) := 'ben_per_asg_eit_ler.ler_asg_chk';
532: l_changed BOOLEAN;
533: l_ler_id NUMBER;
534: l_typ_cd ben_ler_f.typ_cd%Type ;
535: l_ocrd_dt_cd VARCHAR2(30);
536: l_new_val ben_rltd_per_chg_cs_ler_f.new_val%type;
537: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type;
538: l_per_info_chg_cs_ler_rl number;