APPS.BEN_CRT_LER dependencies on BEN_LER_F

Line 23: from ben_ler_f ler

19: cursor get_ler(l_status varchar2) is
20: select ler.ler_id
21: , ler.typ_cd
22: , ler.ocrd_dt_det_cd
23: from ben_ler_f ler
24: where ler.business_group_id = p_new.business_group_id
25: and l_session_date between ler.effective_start_date
26: and ler.effective_end_date -- For Bug 3299709
27: and ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )

Line 106: l_typ_cd ben_ler_f.typ_cd%type ;

102: l_old_val ben_rltd_per_chg_cs_ler_f.old_val%type; -- VARCHAR2(30);
103:
104: l_changed BOOLEAN;
105: l_ler_id NUMBER;
106: l_typ_cd ben_ler_f.typ_cd%type ;
107: l_ocrd_dt_cd VARCHAR2(30);
108: l_per_info_chg_cs_ler_rl number;
109: l_rule_output VARCHAR2(1);
110: l_type VARCHAR2(1);