124: or may not have been stated by the user. Also link in the benefits
125: reporting group. */
126: and (exists (select null
127: from ben_plip_f cpp, 128: ben_rptg_grp bnr, 129: ben_popl_rptg_grp rgr
130: where cpp.pgm_id = c_pgm_id
131: and cpp.pl_id = pln.pl_id
132: and cpp.plip_stat_cd = 'A'