283: cursor c_elig_prfl_dates(cur_p_elig_prfl_id number) is
284: select
285: effective_start_date
286: FROM 287: ben_eligy_prfl_f 288: WHERE
289: trunc(sysdate) between effective_start_date and effective_end_date
290: AND stat_cd = 'A'
291: AND bnft_cagr_prtn_cd = 'CHKLIST'