APPS.BEN_COLLAPSE_LIFE_EVENT dependencies on BEN_PER_IN_LER

Line 248: from ben_per_in_ler pil

244: l_c1_lf_evt_ocrd_dt date;
245: --
246: cursor c1(p_ptnl_ler_for_per_id number) is
247: select pil.per_in_ler_id, pil.lf_evt_ocrd_dt
248: from ben_per_in_ler pil
249: where pil.ptnl_ler_for_per_id = p_ptnl_ler_for_per_id
250: and pil.business_group_id = p_business_group_id
251: and pil.per_in_ler_stat_cd in ('STRTD','PROCD');
252: --

Line 256: from ben_per_in_ler pil,

252: --
253: -- 5677090 Added this cursor
254: cursor get_all_fut_pils(p_lf_evt_ocrd_dt date, p_curr_per_in_ler_id number) is
255: select pil.per_in_ler_id, pil.lf_evt_ocrd_dt, pil.ntfn_dt, ler.name
256: from ben_per_in_ler pil,
257: ben_ler_f ler
258: where pil.person_id = p_person_id
259: and pil.per_in_ler_stat_cd in ('STRTD','PROCD')
260: and pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt