APPS.BEN_DETERMINE_ELIGIBILITY3 dependencies on BEN_PER_IN_LER

Line 193: l_pil_rec ben_per_in_ler%rowtype;

189: l_ptip_rec ben_ptip_f%rowtype;
190: l_plip_rec ben_plip_f%rowtype;
191: l_ass_rec per_all_assignments_f%rowtype;
192: l_loc_rec hr_locations_all%rowtype;
193: l_pil_rec ben_per_in_ler%rowtype;
194: l_jurisdiction_code varchar2(30);
195: --
196: --FONM
197: l_fonm_cvg_strt_dt DATE ;

Line 349: from ben_per_in_ler pil,

345: --
346: cursor c_le (v_per_in_ler_id number,
347: v_effective_date date) is
348: select 'W'
349: from ben_per_in_ler pil,
350: ben_ler_f ler
351: where pil.per_in_ler_id = v_per_in_ler_id
352: and ler.ler_id = pil.ler_id
353: and ler.typ_cd not in ('COMP', 'ABS', 'SCHEDDU', 'GSP', 'IREC') -- iRec