APPS.BEN_COLLAPSE_LIFE_EVENT dependencies on BEN_LER_F

Line 27: -- CWB Changes : Cursor joined to ben_ler_f

23: p_business_group_id in number,
24: p_mode in varchar2,
25: p_effective_date in date) is
26: --
27: -- CWB Changes : Cursor joined to ben_ler_f
28: --
29: cursor c_events is
30: select ptn.ptnl_ler_for_per_id,
31: ptn.ler_id,

Line 37: ben_ler_f ler

33: ptn.lf_evt_ocrd_dt,
34: ptn.ntfn_dt,
35: ptn.object_version_number
36: from ben_ptnl_ler_for_per ptn,
37: ben_ler_f ler
38: where ptn.business_group_id = p_business_group_id
39: and ptn.person_id = p_person_id
40: and ptn.ler_id = ler.ler_id
41: and p_effective_date

Line 243: l_ler_rec ben_ler_f%rowtype;

239: l_unprocd_dt date;
240: l_voidd_dt date;
241: l_lf_evt_ocrd_dt date;
242: l_operation varchar2(30);
243: l_ler_rec ben_ler_f%rowtype;
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

Line 257: ben_ler_f ler

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
261: and pil.per_in_ler_id <> p_curr_per_in_ler_id