314: l_not_hash_found boolean;
315: --
316: cursor c_pgmelp_look is
317: select pgm.pgm_id, pgm.business_group_id 318: from ben_pgm_f pgm 319: where p_effective_date
320: between pgm.effective_start_date
321: and pgm.effective_end_date
322: and exists(select null