228: --
229: cursor c1 is
230: select null
231: from ben_elig_per_typ_prte_f b , 232: per_person_types ppt 233: where b.eligy_prfl_id = p_eligy_prfl_id
234: and b.person_type_id =ppt.person_type_id
235: and ppt.system_person_type NOT IN ('EMP', 'EMP_APL')
236: and b.excld_flag = 'N';