[Home] [Help]
58: will not be picked up. Also added check on eef = eot
59: and p_effective_date between
60: pen.effective_start_date and pen.effective_end_date -1
61: */
62: and pen.effective_end_date = hr_api.g_eot
63: -- 2159253 for enforcing minimum limitation - need to remove comp. objects ending in future
64: -- and pen.enrt_cvg_thru_dt >= c_effective_date
65: --Bug 4361013 fix need to get the ended coverage also in case of
66: --overriden enrollments.
63: -- 2159253 for enforcing minimum limitation - need to remove comp. objects ending in future
64: -- and pen.enrt_cvg_thru_dt >= c_effective_date
65: --Bug 4361013 fix need to get the ended coverage also in case of
66: --overriden enrollments.
67: and ( pen.enrt_cvg_thru_dt = hr_api.g_eot or
68: (pen.enrt_cvg_thru_dt >= c_effective_date and nvl(pen.enrt_ovridn_flag,'N') = 'Y' and ler.typ_cd <> 'SCHEDDU')) --10248940
69: and pen.effective_end_date >= pen.enrt_cvg_thru_dt
70: -- Bug 2677804 Why do we need to exclude this.
71: -- If a participant intinues in the same enrollment
174: --
175: -- Bug No. 6454197 Added code to enforce limitation for enrollment at plantype
176: and (pen.prtt_enrt_rslt_id is null
177: or (pen.prtt_enrt_rslt_id is not null
178: and pen.enrt_cvg_thru_dt <> hr_api.g_eot))
179: /*
180: and epe.oipl_id = cop.oipl_id (+)
181: and c_effective_date between
182: cop.effective_start_date (+) and cop.effective_end_date (+)
235: and p_effective_date between
236: pen.effective_start_date and pen.effective_end_date -1
237: */
238: /*
239: and pen.effective_end_date = hr_api.g_eot
240: and pen.enrt_cvg_thru_dt >= p_effective_date
241: and pen.effective_end_date >= pen.enrt_cvg_thru_dt
242: and (pen.ENRT_OVRID_THRU_DT is NULL
243: or pen.ENRT_OVRID_THRU_DT < p_effective_date)