APPS.BEN_COLLAPSE_LIFE_EVENT dependencies on BEN_PER_IN_LER

Line 251: from ben_per_in_ler pil

247: l_not_present boolean;
248: --
249: cursor c1(p_ptnl_ler_for_per_id number) is
250: select pil.per_in_ler_id, pil.lf_evt_ocrd_dt
251: from ben_per_in_ler pil
252: where pil.ptnl_ler_for_per_id = p_ptnl_ler_for_per_id
253: and pil.business_group_id = p_business_group_id
254: and pil.per_in_ler_stat_cd in ('STRTD','PROCD');
255: --

Line 259: from ben_per_in_ler pil,

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

Line 288: select per_in_ler_id from ben_per_in_ler

284: and lf_evt_ocrd_dt=l_lf_evt_ocrd_dt;
285: l_win_ptnl_ler_for_per_id number;
286:
287: cursor c_get_pil_id is
288: select per_in_ler_id from ben_per_in_ler
289: where ptnl_ler_for_per_id=l_win_ptnl_ler_for_per_id
290: and person_id=p_person_id
291: and business_group_id=p_events.business_group_id
292: and ler_id=p_events.eval_ler_id;