APPS.BEN_GENERATE_COMMUNICATIONS dependencies on BEN_LER_F

Line 4263: ben_ler_f ler

4259: cursor c_pil (p_per_in_ler_id number ) is
4260: select pil.lf_evt_ocrd_dt,
4261: ler.typ_cd
4262: from ben_per_in_ler pil ,
4263: ben_ler_f ler
4264: where pil.per_in_ler_id = p_per_in_ler_id
4265: and ler.ler_id = pil.ler_id
4266: and p_effective_date between
4267: ler.effective_start_date and ler.effective_end_date ;

Line 4274: FROM ben_per_in_ler pil, ben_ler_f ler

4270: --
4271: CURSOR c_get_pil IS
4272: --
4273: SELECT pil.*
4274: FROM ben_per_in_ler pil, ben_ler_f ler
4275: WHERE pil.person_id = p_person_id
4276: AND pil.per_in_ler_stat_cd = 'STRTD'
4277: AND ler.ler_id = pil.ler_id
4278: AND ler.ler_id = NVL (p_ler_id, pil.ler_id)

Line 4302: l_pil_typ_cd ben_ler_f.typ_cd%type ;

4298: --
4299: l_lf_evt_ocrd_dt date ;
4300: -- 3296015
4301: l_pil_lf_evt_ocrd_dt date ;
4302: l_pil_typ_cd ben_ler_f.typ_cd%type ;
4303: --
4304: begin
4305: --
4306: hr_utility.set_location('Entering: '||l_proc,10);