[Home] [Help]
55: will not be picked up. Also added check on eef = eot
56: and p_effective_date between
57: pen.effective_start_date and pen.effective_end_date -1
58: */
59: and pen.effective_end_date = hr_api.g_eot
60: -- 2159253 for enforcing minimum limitation - need to remove comp. objects ending in future
61: -- and pen.enrt_cvg_thru_dt >= c_effective_date
62: --Bug 4361013 fix need to get the ended coverage also in case of
63: --overriden enrollments.
60: -- 2159253 for enforcing minimum limitation - need to remove comp. objects ending in future
61: -- and pen.enrt_cvg_thru_dt >= c_effective_date
62: --Bug 4361013 fix need to get the ended coverage also in case of
63: --overriden enrollments.
64: and ( pen.enrt_cvg_thru_dt = hr_api.g_eot or
65: (pen.enrt_cvg_thru_dt >= c_effective_date and nvl(pen.enrt_ovridn_flag,'N') = 'Y'))
66: and pen.effective_end_date >= pen.enrt_cvg_thru_dt
67: -- Bug 2677804 Why do we need to exclude this.
68: -- If a participant intinues in the same enrollment
171: --
172: -- Bug No. 6454197 Added code to enforce limitation for enrollment at plantype
173: and (pen.prtt_enrt_rslt_id is null
174: or (pen.prtt_enrt_rslt_id is not null
175: and pen.enrt_cvg_thru_dt <> hr_api.g_eot))
176: /*
177: and epe.oipl_id = cop.oipl_id (+)
178: and c_effective_date between
179: cop.effective_start_date (+) and cop.effective_end_date (+)
223: and p_effective_date between
224: pen.effective_start_date and pen.effective_end_date -1
225: */
226: /*
227: and pen.effective_end_date = hr_api.g_eot
228: and pen.enrt_cvg_thru_dt >= p_effective_date
229: and pen.effective_end_date >= pen.enrt_cvg_thru_dt
230: and (pen.ENRT_OVRID_THRU_DT is NULL
231: or pen.ENRT_OVRID_THRU_DT < p_effective_date)