APPS.BEN_COLLAPSE_LIFE_EVENTS dependencies on BEN_LER_F

Line 52: from ben_ler_f ler,

48: cursor c_get_potentials is
49: select ler.typ_cd,
50: ler.ler_id,
51: ptn.lf_evt_ocrd_dt
52: from ben_ler_f ler,
53: ben_ptnl_ler_for_per ptn
54: where ptn.person_id = p_person_id
55: and ptn.ler_id = ler.ler_id
56: -- CWB Changes

Line 70: from ben_ler_f ler

66: -- whether the passed in context is a derived factor life event.
67: --
68: cursor c_life_event is
69: select null
70: from ben_ler_f ler
71: where ler.ler_id = p_ler_id
72: and ler.typ_cd in ('DRVDAGE','DRVDCAL','DRVDCMP',
73: 'DRVDHRW','DRVDLOS','DRVDTPF')
74: and p_effective_date

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

193: and l_effective_date
194: between paf.effective_start_date
195: and paf.effective_end_date;
196: --
197: -- CWB Changes : Cursor joined to ben_ler_f
198: --
199: cursor c_person_life is
200: select ptn.lf_evt_ocrd_dt
201: from ben_ptnl_ler_for_per ptn,

Line 202: ben_ler_f ler

198: --
199: cursor c_person_life is
200: select ptn.lf_evt_ocrd_dt
201: from ben_ptnl_ler_for_per ptn,
202: ben_ler_f ler
203: where ptn.person_id = l_person_id
204: and ptn.ptnl_ler_for_per_stat_cd in ('UNPROCD','DTCTD')
205: and ptn.ler_id = p_ler_id
206: and ler.ler_id = ptn.ler_id

Line 215: ben_ler_f ler2

211: between ler.effective_start_date
212: and ler.effective_end_date
213: and ptn.rowid = (select min(ptn2.rowid)
214: from ben_ptnl_ler_for_per ptn2,
215: ben_ler_f ler2
216: where ptn2.person_id = ptn.person_id
217: and ptn2.ler_id = ler2.ler_id
218: and l_effective_date
219: between ler2.effective_start_date

Line 227: ben_ler_f ler3

223: ('UNPROCD','DTCTD')
224: and ptn2.lf_evt_ocrd_dt =
225: (select min(ptn3.lf_evt_ocrd_dt)
226: from ben_ptnl_ler_for_per ptn3,
227: ben_ler_f ler3
228: where ptn3.person_id = ptn2.person_id
229: and ptn3.ler_id = ler3.ler_id
230: and l_effective_date
231: between ler3.effective_start_date