[Home] [Help]
4999: -- Bug 5766477.
5000: --
5001: cursor c_get_dpnt(p_effective_date in date) is
5002: select pdp.*
5003: from ben_elig_cvrd_dpnt_f pdp
5004: where pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5005: and pdp.cvg_thru_dt is not null
5006: and pdp.effective_end_date <> hr_api.g_eot
5007: and p_effective_date