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 244: l_ler_rec ben_ler_f%rowtype;

240: l_unprocd_dt date;
241: l_voidd_dt date;
242: l_lf_evt_ocrd_dt date;
243: l_operation varchar2(30);
244: l_ler_rec ben_ler_f%rowtype;
245: l_c1_lf_evt_ocrd_dt date;
246: l_flag boolean;
247: l_not_present boolean;
248: --

Line 260: ben_ler_f ler

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