11273: where p_effective_date
11274: between elp.effective_start_date
11275: and elp.effective_end_date
11276: and exists(select null
11277: from ben_elig_optd_mdcr_prte_f eom
11278: where p_effective_date
11279: between eom.effective_start_date
11280: and eom.effective_end_date
11281: and eom.eligy_prfl_id = elp.eligy_prfl_id)
11284: cursor c_elpeom_inst is
11285: select eom.eligy_prfl_id,
11286: eom.optd_mdcr_flag,
11287: eom.exlcd_flag
11288: from ben_elig_optd_mdcr_prte_f eom
11289: where p_effective_date
11290: between eom.effective_start_date
11291: and eom.effective_end_date
11292: order by eom.eligy_prfl_id,