[Home] [Help]
35: epe.MUST_ENRL_ANTHR_PL_ID,
36: 'N' dpnt_cvd_by_othr_apls_flag,
37: -9999999999999999999999999999999999999 opt_id
38: from ben_prtt_enrt_rslt_f pen,
39: ben_elig_per_elctbl_chc epe,
40: /*Bug#: 3255596: Fetching plip_id from CPP record
41: when plip_id is null in EPE record*/
42: ben_plip_f cpp,
43: ben_ler_f ler --10248940
140: /*
141: cop.opt_id
142: */
143: from ben_prtt_enrt_rslt_f pen,
144: ben_elig_per_elctbl_chc epe,
145: ben_pil_elctbl_chc_popl pel,
146: /*
147: ben_oipl_f cop,
148: */
184: /* Bug 10435034: On reprocessing a LE, if Participant is eligible for a new Plan in a new
185: Plan Type, do not consider the new plan type for multi row validation*/
186: and ( (ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL
187: and epe.pl_typ_id in (select distinct epe1.pl_typ_id
188: from ben_elig_per_elctbl_chc epe1
189: where epe1.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id)
190: )
191: or (ben_manage_life_events.g_bckdt_per_in_ler_id is null)
192: )
220: epe.MUST_ENRL_ANTHR_PL_ID,
221: pln.dpnt_cvd_by_othr_apls_flag,
222: cop.opt_id
223: from ben_prtt_enrt_rslt_f pen,
224: ben_elig_per_elctbl_chc epe,
225: ben_oipl_f cop,
226: ben_pl_f pln
227: where pen.person_id = p_person_id
228: and pen.prtt_enrt_rslt_stat_cd is null
284: epe.MUST_ENRL_ANTHR_PL_ID,
285: 'N' dpnt_cvd_by_othr_apls_flag,
286: cop.opt_id
287: from ben_prtt_enrt_rslt_f pen,
288: ben_elig_per_elctbl_chc epe,
289: ben_oipl_f cop,
290: ben_per_in_ler pil
291: where pil.person_id = p_person_id
292: and pil.per_in_ler_stat_cd = 'STRTD'